DBMS – Questions & Proper Answers (Expert Verified)
A relation is in second normal form (2NF) if and only if it is in 1NF and ________.
Right Ans - all non-key attributes are determined by the entire primary key
A combination of one or more columns used to identify particular rows in a
relation is a ________. Right Ans - key
The reason(s) for having relations is to ________. Right Ans - store functional
dependencies
A combination of two or more columns used to identify particular rows in a
relation is a ________. Right Ans - composite key
A relation is in third normal form (3NF) if and only if it is in 2NF and ________.
Right Ans - there are no non-key attributes determined by another non-key
attribute
If a relation is in BCNF, and each multivalued dependency has been moved to a
relation of its own, then the relation is in ________. Right Ans - Fourth
Normal Form
An attribute is also known as a ________. Right Ans - field
Which of the following is true about the functional dependency (A, B) → (C,
D)? Right Ans - A and B together determine D.
Given the functional dependency (A, B) → C, (A, B) is a(n) ________. Right Ans
- determinant
composite determinant
When designing a database, one of the candidate keys in a relation is selected
as the ________. Right Ans - primary key
A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and
________. Right Ans - every determinant is a candidate key
A tuple is also known as a ________. Right Ans - row
A relation is in second normal form (2NF) if and only if it is in 1NF and ________.
Right Ans - all non-key attributes are determined by the entire primary key
A combination of one or more columns used to identify particular rows in a
relation is a ________. Right Ans - key
The reason(s) for having relations is to ________. Right Ans - store functional
dependencies
A combination of two or more columns used to identify particular rows in a
relation is a ________. Right Ans - composite key
A relation is in third normal form (3NF) if and only if it is in 2NF and ________.
Right Ans - there are no non-key attributes determined by another non-key
attribute
If a relation is in BCNF, and each multivalued dependency has been moved to a
relation of its own, then the relation is in ________. Right Ans - Fourth
Normal Form
An attribute is also known as a ________. Right Ans - field
Which of the following is true about the functional dependency (A, B) → (C,
D)? Right Ans - A and B together determine D.
Given the functional dependency (A, B) → C, (A, B) is a(n) ________. Right Ans
- determinant
composite determinant
When designing a database, one of the candidate keys in a relation is selected
as the ________. Right Ans - primary key
A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and
________. Right Ans - every determinant is a candidate key
A tuple is also known as a ________. Right Ans - row
