Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q111: Which of the following is not a command in Data Definition Language (DDL)?
- A: CREATE
- B: ALTER
- C: DROP
- D: SELECT
View Answer
D
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
View Answer
A
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
View Answer
A
Q114: In a relational database, which key uniquely identifies each row?
- A: Primary key
- B: Foreign key
- C: Composite key
- D: Surrogate key
View Answer
A
Q115: Which command in SQL is used to modify the structure of a table?
- A: ALTER
- B: INSERT
- C: DELETE
- D: UPDATE
View Answer
A
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
View Answer
B
Q117: Who developed the Entity-Relationship modeling?
- A: Edgar Codd
- B: Peter Chen
- C: Bill Gates
- D: Larry Ellison
View Answer
B
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
View Answer
B
Q119: When was the Entity-Relationship modeling published?
- A: 1976
- B: 1980
- C: 1965
- D: 1995
View Answer
A
Q120: Which of the following is NOT a main component of an ERD?
- A: Entity
- B: Relationships
- C: Attributes
- D: Tables
View Answer
D