It is the data contained in database that is not redundant
It is the data contained in database that is accurate and consistant
It is the data contained in database that is secured
It is the data contained in database that is shared
Q.4.
A logical schema
is the entire database
is a standard way of organizing information into accessible parts
Describes how data is actually stored
None of these
Q.5.
Logical design of database, is known to be
Database relation
Database instance
Database entity
Database Schema
Q.6.
A table joined with itself is called
Join
Self Join
Outer Join
Equi Join
Right Join
Q.7.
The set of all possible values that an attribute may contain is called the ___________ of an attribute. 1
(a) Domain
(b) Relation
(c) Set
(d) Schema
Q.8.
An advantage of the database management approach is
A. Data is dependent on programs.
B. Data redundancy increases.
C. Data is integrated and can be accessed by multiple programs.
D. None of the above
Q.9.
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
a) Candidate
b) Primary
c) Super
d) Sub
Q.10.
A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
a) Rows
b) Key
c) Attribute
d) Fields
Q.11.
Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
a) Candidate key
b) Sub key
c) Super key
d) Foreign key
Q.12.
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
Q.13.
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
Q.14.
What is the purpose of *?
Selects ALL fields from the table
Selects only the first field in the table
Selects the last field in the table
Shows only the first row in the table
Q.15.
In ER diagram relationship type is represented by
Ellipse
Dashed Ellipse
Rectangle
Diamond
Q.16.
What database level is closest to the user
External
Internal
Physical
Conceptual
Q.17.
An .............. can be a real-world object, either animate or inanimate, that can be easily identifiable.
Entity
Entity set
Attribute
Transaction
Q.18.
Atomicity, Consistency, Isolation, and Durability − commonly known as ........... properties
AID
ADIC
ACID
DBMS
Q.19.
A .............. is a very small unit of a program and it may contain several low-level tasks.
Attribute
Table
Normalization
Transaction
Q.20.
A ........... can be defined as a group of tasks.
Transaction
Normalization
Schema
Instance
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.