Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 19
Q301:
Which inference rule allows us to deduce new functional dependencies from existing ones?
A. Reflexivity
B. Augmentation
C. Transitivity
D. Additivity
Correct Answer:
C
Chapter: 19
Q302:
What does the Augmentation rule state?
A. If A → B, then AC → BC
B. If A → B, then B → A
C. If A → B and B → C, then A → C
D. If A → B, then A → A
Correct Answer:
A
Chapter: 19
Q303:
If A → B and B → C, what does Transitivity allow us to infer?
A. A → C
B. A → B
C. B → C
D. A → B, C
Correct Answer:
A
Chapter: 19
Q304:
Which rule states that if A → B and A → C, then A → BC?
A. Additivity
B. Projectivity
C. Pseudo Transitivity
D. Transitivity
Correct Answer:
A
Chapter: 19
Q305:
What is the requirement for a relation to be in First Normal Form (1NF)?
A. All attributes must be single-valued
B. No repeating groups or multivalued attributes
C. Every attribute must have a unique name
D. All attributes must be numeric
Correct Answer:
B
Chapter: 19
Q306:
Which normal form requires all nonkey attributes to be fully functionally dependent on the key?
A. First Normal Form
B. Second Normal Form
C. Third Normal Form
D. Boyce-Codd Normal Form
Correct Answer:
B
Chapter: 19
Q307:
In the provided example, which attribute is a key for the student relation?
A. stId
B. stName
C. prName
D. credits
Correct Answer:
A
Chapter: 19
Q308:
If stId → stName, stAdr, prName, credits, then what can be inferred about stId?
A. It is a super key
B. It is a foreign key
C. It is a non-key attribute
D. It is a candidate key
Correct Answer:
A
Chapter: 19
Q309:
What does the term "Projectivity" refer to in inference rules?
A. Breaking down a functional dependency into simpler dependencies
B. Combining multiple dependencies into one
C. Adding more attributes to a dependency
D. Removing attributes from a dependency
Correct Answer:
A
Chapter: 19
Q310:
In the given relation, what is required to convert it to First Normal Form (1NF)?
A. Remove repeating groups
B. Remove all NULL values
C. Ensure all values are unique
D. Ensure all attributes are numeric
Correct Answer:
A
Chapter: 20
Q311:
A relation is in second normal form if and only if it is in _______ and all nonkey attributes are fully functionally dependent on the key.
A. First Normal Form
B. Third Normal Form
C. Fourth Normal Form
D. Fifth Normal Form
Correct Answer:
A
Chapter: 20
Q312:
What anomaly occurs when inserting a new course without any students registered in it?
A. Insertion Anomaly
B. Deletion Anomaly
C. Update Anomaly
D. Redundancy
Correct Answer:
A
Chapter: 20
Q313:
Which of the following is a requirement for a relation to be in second normal form (2NF)?
A. All non-key attributes must be functionally dependent on a composite key
B. All attributes must be functionally dependent on a single attribute key
C. No non-key attributes should be present in the relation
D. All attributes should be fully dependent on the primary key
Correct Answer:
B
Chapter: 20
Q314:
In the provided example, the course ID C3456 is repeated for which attribute?
A. Faculty ID and Room
B. Student ID and Name
C. Grade and Room
D. Student ID and Grade
Correct Answer:
A
Chapter: 20
Q315:
The relation STD(stId, stName, stAdr, prName, prCrdts) has a transitive dependency if:
A. prCrdts depends on stAdr
B. stName depends on prCrdts
C. prCrdts depends on prName
D. stAdr depends on stName
Correct Answer:
C
Chapter: 20
Q316:
In which normal form are the relations STD (stId, stName, stAdr, prName) and PROGRAM (prName, prCrdts) considered to be?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Fourth Normal Form (4NF)
Correct Answer:
C
Chapter: 20
Q317:
Which anomaly occurs when deleting a record of a student, and the information about the course is also deleted?
A. Deletion Anomaly
B. Insertion Anomaly
C. Update Anomaly
D. Redundancy
Correct Answer:
A
Chapter: 20
Q318:
A relation is in Boyce-Codd Normal Form (BCNF) if:
A. Every determinant is a candidate key
B. Every non-key attribute is functionally dependent on the primary key
C. Every attribute is fully functionally dependent on the key
D. All tables are in 3NF
Correct Answer:
A
Chapter: 20
Q319:
Which of the following is a higher normal form after BCNF?
A. Fourth Normal Form (4NF)
B. Third Normal Form (3NF)
C. Fifth Normal Form (5NF)
D. Domain-Key Normal Form (DKNF)
Correct Answer:
A
Chapter: 20
Q320:
In the example given, which of the following decompositions removes the anomalies?
A. STD (stId, stName), COURSE (crId, fId, room), CLASS (crId, stId, grade)
B. STD (stId, stName, stAdr), PROGRAM (prName, prCrdts)
C. CLASS (crId, stId, fId, room), STD (stId, stName, grade)
D. STD (stId, stName), COURSE (crId, room), CLASS (crId, stId, grade)
Correct Answer:
A