CommerceThe Relational Model And Normalization MCQs
Practice The Relational Model And Normalization MCQs for competitive exams.
The Relational Model And Normalization MCQs
Practice questions from this topic.
A primary key is a composite key that was selected to be the main identifier for the relation.
- A. True
- B. False
Correct Answer: A
In a relation, the rows are sometimes called "fields".
- A. True
- B. False
Correct Answer: B
A relation has cells that hold multi-value entries.
- A. True
- B. False
Correct Answer: B
A functional dependency is always an equation.
- A. True
- B. False
Correct Answer: B
A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.
- A. True
- B. False
Correct Answer: A
Relations are categorized into normal forms according to the referential integrity constraints that they have.
- A. True
- B. False
Correct Answer: A
Given the functional dependency R → S , R is called the determinant.
- A. True
- B. False
Correct Answer: A
Keys made up of two or more attributes are called composite keys.
- A. True
- B. False
Correct Answer: A
A key is a group of one or more attributes that uniquely identifies a row.
- A. True
- B. False
Correct Answer: A
A functional dependency is a relationship between or among attributes.
- A. True
- B. False
Correct Answer: A
In a relation, the order of the columns does not matter.
- A. True
- B. False
Correct Answer: A
In a relation, the columns are sometimes called "attributes".
- A. True
- B. False
Correct Answer: A