Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 7
Q101:
Who proposed the relational model of data?
A. E.F. Codd
B. Donald Knuth
C. Tim Berners-Lee
D. Edgar F. Frank
Correct Answer:
A
Chapter: 7
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
Correct Answer:
B
Chapter: 7
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
Correct Answer:
C
Chapter: 7
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
Correct Answer:
D
Chapter: 7
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
Correct Answer:
A
Chapter: 7
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)
Correct Answer:
C
Chapter: 7
Q107:
What operation does not fall under Data Manipulation Language (DML)?
A. UPDATE
B. DELETE
C. INSERT
D. CREATE
Correct Answer:
D
Chapter: 7
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
Correct Answer:
B
Chapter: 7
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
Correct Answer:
C
Chapter: 7
Q110:
Fill-in-the-Blank: The command to permanently apply a transaction to the database is ______.
A. INSERT
B. COMMIT
C. UPDATE
D. DELETE
Correct Answer:
B
Chapter: 7
Q111:
Which of the following is not a command in Data Definition Language (DDL)?
A. CREATE
B. ALTER
C. DROP
D. SELECT
Correct Answer:
D
Chapter: 7
Q112:
Which Codd Rule ensures that the application should not be affected by changes in the database schema?
A. Logical Data Independence
B. Integrity Independence
C. Physical Data Independence
D. Non-Subversion Rule
Correct Answer:
A
Chapter: 7
Q113:
What kind of syntax is required for a relational database query language, according to Codd's Powerful Language Rule?
A. Left-to-right syntax
B. Carriage-return based syntax
C. Object-oriented syntax
D. Syntactic sugar
Correct Answer:
A
Chapter: 7
Q114:
In a relational database, which key uniquely identifies each row?
A. Primary key
B. Foreign key
C. Composite key
D. Surrogate key
Correct Answer:
A
Chapter: 7
Q115:
Which command in SQL is used to modify the structure of a table?
A. ALTER
B. INSERT
C. DELETE
D. UPDATE
Correct Answer:
A
Chapter: 7
Q116:
Fill-in-the-Blank: In relational databases, the structure of the entire database is stored in an ______, which can be accessed by authorized users.
A. index
B. data dictionary
C. view
D. foreign key
Correct Answer:
B
Chapter: 8
Q117:
Who developed the Entity-Relationship modeling?
A. Edgar Codd
B. Peter Chen
C. Bill Gates
D. Larry Ellison
Correct Answer:
B
Chapter: 8
Q118:
What does an Entity-Relationship Diagram (ERD) represent?
A. Business processes
B. The relationships between data in a database
C. Programming code
D. Web development structures
Correct Answer:
B
Chapter: 8
Q119:
When was the Entity-Relationship modeling published?
A. 1976
B. 1980
C. 1965
D. 1995
Correct Answer:
A
Chapter: 8
Q120:
Which of the following is NOT a main component of an ERD?
A. Entity
B. Relationships
C. Attributes
D. Tables
Correct Answer:
D