Score: 0
Database Management System MCQS
The Relational Model and Normalization - Database MCQS
The Relational Model and Normalization - Database MCQS | MCQs & Past Papers
Study Mode
Show correct answers and hints
1
A common approach to normalization is to ___ the larger table into smaller tables and link them together by using relationships.
2
In practical applications, how many types of Normal Forms are there?
3
Which of the following is a type of Normal Form?
4
When a relation contains an atomic value, it is a ___ relation.
5
2NF relations are those that are in 1NF with all the attribute types dependent on the ___ key.
6
A relation is in ___ if it is in Boyce Codd normal form and does not have any multivalued dependencies.
7
What is TRUE about the First Normal Form (1NF)?
8
Neither multivalued nor composite attributes, nor their combinations, may be used in the ___ normal form.
9
What is TRUE about the Second Normal Form (2NF)?
10
What is TRUE about the Third Normal Form (3NF)?
11
What is TRUE about BCNF?
12
If every non-key attribute is functionally dependent on the primary key,
13
Which normal form deals with eliminating partial dependencies?
14
In which normal form should a non-prime attribute be fully functionally dependent on a super key?
15
Which normal form eliminates transitive dependencies?
16
Which normal form allows for multivalued dependencies to be eliminated?
17
Which normal form is stricter than Boyce-Codd Normal Form (BCNF)?
18
In which normal form is a table that contains a composite key considered to be?
19
What is a functional dependency in DBMS?
20
Which normal form is also known as the "key normal form"?