Normalization interview questions
Normalization interview questions
Take as many assements as you can to improve your validate your skill rating
Total Questions: 10
1. A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.
Correct Answer is : Candidate
2. The ___________ normalization introduced by Chris Date, Hugh Darwen, and Nikos Lorentzos.
Correct Answer is : Sixth
3. A table is in 3NF if it is in 2NF and if it has no ____________
Correct Answer is : Transitive Dependencies
4. Every constraint on the table is a logical consequence of the table’s
Correct Answer is : Domain/key normal form
5. A ___________ is an indirect functional dependency, one in which X->Z only by virtue of X->Y and Y->Z.
Correct Answer is : Transitive Dependencies
6. In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the _________ key.
Correct Answer is : Candidate
7. Anomalies are avoided by splitting the offending relation into multiple relations, is also known as
Correct Answer is : Decomposition
8. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
Correct Answer is : A -> B
9. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Correct Answer is : Referential Integrity Constraint
10. Which of the following is not a restriction for a table to be a relation?
Correct Answer is : The columns must be ordered
