Quiznetik
DataBase Management System (DBMS) | Set 15
1. A relation between 2 set of attributes is called as
A. Join dependency
B. Association
C. Functional Dependency
D. Multivalued dependency
Correct : C. Functional Dependency
2. In 1NF, the value of the attribute must be
A. Atomic
B. Single
C. Multivalued
D. Null
Correct : D. Null
3. The process of Normalization is
A. Iterative
B. Non-reversible
C. Reversible
D. None
Correct : A. Iterative
4. Which normal form is most desirable ?
A. DKNF
B. 3 NF
C. BCNF
D. 4 NF
Correct : B. 3 NF
5. A functional dependency is a relationship between
A. Tables
B. Columns
C. Attributes
D. Rows
Correct : C. Attributes
6. Two or more attributes that can be a key are called :
A. determinants
B. primary key
C. Composite key
D. foreign key
Correct : C. Composite key
7. Cartesian product in relational algebra is
A. a Unary operator.
B. a Binary operator.
C. a Ternary operator
D. not defined
Correct : B. a Binary operator.
8. In the relational modes, cardinality is termed as:
A. Number of tuples.
B. Number of attributes.
C. Number of tables.
D. Number of constraints.
Correct : A. Number of tuples.
9. Relational calculus is a
A. Procedural language.
B. Non- Procedural language.
C. Data definition language.
D. High level language
Correct : B. Non- Procedural language.
10. In a relational database a referential integrity constraint can be specified with the help of
A. primary key
B. foreign key
C. secondary key
D. none of the above
Correct : B. foreign key
11. A super key is a set of one or more attributes that, taken collectively, allow us
A. to identify uniquely an entity in the entity set
B. to make the key most powerful for faster retrieval
C. to increase effectiveness of database access
D. none of the above
Correct : A. to identify uniquely an entity in the entity set
12. 4NF is designed to cope with:
A. Transitive dependency
B. Join dependency
C. Multi valued dependency
D. None of these
Correct : C. Multi valued dependency
13. A relational database developer refers to a record as
A. a criteria.
B. a relation.
C. a tuple.
D. an attribute.
Correct : C. a tuple.
14. The relational model feature is that there
A. is no need for primary key data.
B. is much more data independence than some other database models.
C. are explicit relationships among records.
D. are tables with many dimensions.
Correct : B. is much more data independence than some other database models.
15. SET concept is used in :
A. Network Model
B. Hierarchical Model
C. Relational Model
D. None of these
Correct : A. Network Model
16. Relational Algebra is
A. Data Definition Language .
B. Meta Language
C. Procedural query Language
D. None of the above
Correct : C. Procedural query Language