The Relational Model and Normalization - Database MCQ Questions and answers- Technical Aptitude

Home / Database / The Relational Model And Normalization

31.
In a relation, the order of the columns does not matter.

Answer & Solution Discuss in Board Save for Later

32.
A functional dependency is a relationship between or among attributes.

Answer & Solution Discuss in Board Save for Later

33.
A key is a group of one or more attributes that uniquely identifies a row.

Answer & Solution Discuss in Board Save for Later

34.
Keys made up of two or more attributes are called composite keys.

Answer & Solution Discuss in Board Save for Later

35.
Given the functional dependency R → S , R is called the determinant.

Answer & Solution Discuss in Board Save for Later

36.
Relations are categorized into normal forms according to the referential integrity constraints that they have.

Answer & Solution Discuss in Board Save for Later

37.
A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.

Answer & Solution Discuss in Board Save for Later

38.
A functional dependency is always an equation.

Answer & Solution Discuss in Board Save for Later

39.
A relation has cells that hold multi-value entries.

Answer & Solution Discuss in Board Save for Later

40.
In a relation, the rows are sometimes called "fields".

Answer & Solution Discuss in Board Save for Later