Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q101: Who proposed the relational model of data?
- A: E.F. Codd
- B: Donald Knuth
- C: Tim Berners-Lee
- D: Edgar F. Frank
View Answer
A
Q102: Which Codd rule emphasizes that all data must be represented in tables?
- A: Access Rule
- B: Information Rule
- C: Null Rule
- D: View Updating Rule
View Answer
B
Q103: What is the purpose of the primary key in a relational database?
- A: To identify columns
- B: To identify tables
- C: To identify unique rows
- D: To link databases
View Answer
C
Q104: Codd's Guaranteed Access Rule emphasizes the importance of which key element in data access?
- A: Column name
- B: Foreign key
- C: Data type
- D: Primary key
View Answer
D
Q105: Which of the following rules ensures the independence of physical storage from logical access?
- A: Physical Data Independence
- B: Logical Data Independence
- C: Integrity Independence
- D: Distribution Independence
View Answer
A
Q106: Which SQL language subset is responsible for creating and modifying database structures?
- A: Data Control Language (DCL)
- B: Data Manipulation Language (DML)
- C: Data Definition Language (DDL)
- D: Data Retrieval Language (DRL)
View Answer
C
Q107: What operation does not fall under Data Manipulation Language (DML)?
- A: UPDATE
- B: DELETE
- C: INSERT
- D: CREATE
View Answer
D
Q108: Which rule supports the use of an online catalog in relational databases?
- A: Systematic Handling of Null
- B: Active Online Catalogue
- C: Relational Level Operations
- D: Non-Subversion Rule
View Answer
B
Q109: Fill-in-the-Blank: SQL is a ______ programming language designed for managing data in relational database systems.
- A: object-oriented
- B: procedural
- C: declarative
- D: functional
View Answer
C
Q110: Fill-in-the-Blank: The command to permanently apply a transaction to the database is ______.
- A: INSERT
- B: COMMIT
- C: UPDATE
- D: DELETE
View Answer
B