1. A functional dependency is a relationship between or among
(A) Entities
(B) Rows
(C) Tables
(D) Attributes
2. The database design prevents some data from being stored due to _______.
(A) Deletion anomalies
(B) Update anomalies
(C) Insertion anomalies
(D) Selection anomalies
3. If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be:
(A) 3NF
(B) 1NF
(C) 2NF
(D) Well-structured
4. A relation is in 2NF if:
(A) All of the above
(B) Any non-key attribute dependent on part of the candidate key is moved to another relation
(C) It must already be in 1NF
(D) All the values of non-key attributes are dependent fully on the candidate key
5. In which form of function there is no partial functional dependencies?
(A) BCNF
(B) 3NF
(C) 2NF
(D) 4NF
6. In which normal form Boyce-Codd can operate?
(A) First normal form
(B) Third normal form
(C) Second normal form
(D) All of the above
7. In relational databases, the table is also called _____?
(A) Tuple
(B) File
(C) Relation
(D) None
8. In 3NF a non-key attribute must not depend on a _____?
(A) Non key attribute
(B) Key attribute
(C) Composite key
(D) Sort key
9. Different attributes in two different tables having same name are referred to as _____?
(A) Synonym
(B) Acronym
(C) Homonym
(D) Mutually exclusive
10. Every relation must have _____?
(A) Secondary key
(B) Candidate key
(C) Primary key
(D) Mutually exclusiveness
11. The goal of normalization is to ____?
(A) Increase number of relations
(B) Get stable data structure
(C) Increase redundancy
(D) None of these
12. A rule that states that each foreign key value must match a primary key value in the other relation is called _____?
(A) Referential integrity constraint
(B) Key match rule
(C) Entity key group rule
(D) Foreign / primary match rule
13. Two or more attributes having different names but same meaning are called _____?
(A) Synonym
(B) Aliases
(C) Homonym
(D) Alternate attributes
14. A constraint between two attributes is called _____?
(A) Functional dependency
(B) Attribute dependency
(C) Functional relation
(D) Functional relation constraint