In a relation, the order of the rows matters.
Select an option to see the answer and solution.
Database · all questionsThe Relational Model and Normalization
The Relational Model and Normalization
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
44
Questions
2/3
Page
Pick an option on a question to see the right answer and solution.
In a relation, the rows are sometimes called "records".
Select an option to see the answer and solution.
A relation is a two-dimensional table.
Select an option to see the answer and solution.
Any table that meets the definition of a relation is said to be in first normal form.
Select an option to see the answer and solution.
Given the functional dependency R → (S,T) , then it is also true that R → S.
Select an option to see the answer and solution.
A candidate key is a determinant that determines all the other columns is a relation.
Select an option to see the answer and solution.
The only reason for the existence of relations is to store instances of functional dependencies.
Select an option to see the answer and solution.
A relation is in 5NF when multivalued dependencies are isolated in their own relation.
Select an option to see the answer and solution.
The functional dependency R → S means that the value of S can be determined when we are given a value of R.
Select an option to see the answer and solution.
In a relation, the columns are sometimes called "attributes".
Select an option to see the answer and solution.
In a relation, the order of the columns does not matter.
Select an option to see the answer and solution.
A functional dependency is a relationship between or among attributes.
Select an option to see the answer and solution.
A key is a group of one or more attributes that uniquely identifies a row.
Select an option to see the answer and solution.
Keys made up of two or more attributes are called composite keys.
Select an option to see the answer and solution.
Given the functional dependency R → S , R is called the determinant.
Select an option to see the answer and solution.
Relations are categorized into normal forms according to the referential integrity constraints that they have.
Select an option to see the answer and solution.
A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.
Select an option to see the answer and solution.
A functional dependency is always an equation.
Select an option to see the answer and solution.
A relation has cells that hold multi-value entries.
Select an option to see the answer and solution.
In a relation, the rows are sometimes called "fields".
Select an option to see the answer and solution.