Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 12
Q181:
Which anomaly may lead to data inconsistency if not all instances of data are updated?
A. Insert Anomaly
B. Delete Anomaly
C. Update Anomaly
D. Merge Anomaly
Correct Answer:
C
Chapter: 12
Q182:
Fill in the blank: The presence of an insert anomaly indicates that a row cannot be added without adding ________ data.
A. related
B. redundant
C. historical
D. calculated
Correct Answer:
A
Chapter: 12
Q183:
In the context of anomalies, what is typically lost due to a delete anomaly?
A. Historical data
B. Unrelated data
C. Customer data
D. Product data
Correct Answer:
C
Chapter: 12
Q184:
Which type of anomaly can result in multiple updates of the same data item, potentially leading to inconsistencies?
A. Insert Anomaly
B. Delete Anomaly
C. Update Anomaly
D. Redundancy Anomaly
Correct Answer:
C
Chapter: 12
Q185:
Fill in the blank: Update anomalies occur when the same information is expressed on multiple rows and ________.
A. only some instances are updated
B. all instances are updated
C. no instances are updated
D. redundant data is removed
Correct Answer:
A
Chapter: 12
Q186:
Which of the following is NOT a type of anomaly mentioned?
A. Insert Anomaly
B. Delete Anomaly
C. Update Anomaly
D. Merge Anomaly
Correct Answer:
D
Chapter: 12
Q187:
What is the primary cause of anomalies according to the content?
A. Large database size
B. Poor database design and planning
C. High data redundancy
D. Complex queries
Correct Answer:
B
Chapter: 12
Q188:
Fill in the blank: An update anomaly can lead to ________ across the database if not all instances are updated.
A. data consistency
B. data integrity
C. data redundancy
D. data inconsistency
Correct Answer:
D
Chapter: 13
Q189:
What is the primary goal of database normalization?
A. Increase redundancy
B. Reduce data redundancy
C. Improve data retrieval speed
D. Simplify data entry
Correct Answer:
B
Chapter: 13
Q190:
Which normal form requires that no two rows of data contain repeating groups of information?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Fourth Normal Form (4NF)
Correct Answer:
A
Chapter: 13
Q191:
Fill in the blank: The process of normalization includes three steps known as ________.
A. Normal Forms
B. Data Integrity
C. Indexing
D. Entity Relationships
Correct Answer:
A
Chapter: 13
Q192:
What does the First Normal Form (1NF) ensure about rows in a table?
A. They contain repeating groups
B. Each row must be unique
C. They must have multiple primary keys
D. They can have duplicated data
Correct Answer:
B
Chapter: 13
Q193:
Which normal form is concerned with removing partial dependencies?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Fourth Normal Form (4NF)
Correct Answer:
B
Chapter: 13
Q194:
Fill in the blank: The Second Normal Form (2NF) requires that each non-key attribute should be ________ on the primary key.
A. partially dependent
B. fully dependent
C. redundantly dependent
D. conditionally dependent
Correct Answer:
B
Chapter: 13
Q195:
What is the main issue addressed by the Third Normal Form (3NF)?
A. Redundancy in data
B. Partial dependency
C. Transitive dependency
D. Incomplete dependency
Correct Answer:
C
Chapter: 13
Q196:
Fill in the blank: The Third Normal Form (3NF) removes transitive dependency by ensuring that non-prime attributes are only dependent on ________.
A. other non-prime attributes
B. the primary key
C. partial keys
D. foreign keys
Correct Answer:
B
Chapter: 13
Q197:
What happens if a table is in 2NF but not in 3NF?
A. It is considered normalized
B. It needs to be decomposed to remove transitive dependency
C. It should be updated to a higher normal form
D. It can be used as it is
Correct Answer:
B
Chapter: 13
Q198:
Fill in the blank: An example of a table that is not in 3NF would be one where the ________ is determined by another non-prime attribute.
A. primary key
B. total registered courses
C. foreign key
D. status
Correct Answer:
D
Chapter: 13
Q199:
Which table would NOT be considered in Third Normal Form (3NF)?
A. Student table with primary key Sid and attributes Sname, Total_Registered_Courses
B. Course table with attributes Cid, Cname, Credithrs
C. Student-Status table with Total_courses_registered, Status
D. Airport table with attributes aid, Flight#, gate#, aname, runway#
Correct Answer:
D
Chapter: 13
Q200:
Fill in the blank: In the normalization process, the table "Airport" was split into "Airport-Info" and "Airport" to address ________.
A. redundancy
B. partial dependency
C. transitive dependency
D. repeating groups
Correct Answer:
B