Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q11: Which of the following is an example of a DBMS?
- A: Student record
- B: Oracle
- C: Microsoft Excel
- D: Telephone directory
View Answer
B
Q12: What is one major benefit of using a database over manual handling of data?
- A: Increases redundancy
- B: Reduces data loss risk
- C: Makes data harder to access
- D: Increases risk of errors
View Answer
B
Q13: What are the main components of a DBMS?
- A: Data, user, hardware, software, procedures
- B: Data, hardware, CPU, RAM, operating system
- C: Information, user, hard drive, application
- D: User, CPU, data, files, information
View Answer
A
Q14: What is the basic architectural unit of databases that determines the structure of a database?
- A: Data model
- B: Database table
- C: Data entity
- D: Data field
View Answer
A
Q15: What does a data model define in a system?
- A: Only the data storage
- B: Data processing and storage
- C: Only data retrieval
- D: Only data collection
View Answer
B
Q16: What happens to a data model once data is inserted into the database?
- A: It becomes easier to change
- B: It becomes difficult to change
- C: It remains flexible
- D: It automatically updates
View Answer
B
Q17: What is a flat file database?
- A: A database stored as an ordinary file
- B: A complex relational database
- C: A hierarchical database
- D: An object-oriented database
View Answer
A
Q18: How is data stored in a flat file database?
- A: In a tree-like structure
- B: In a single table without interrelationships
- C: In multiple tables with interrelationships
- D: In a web-like structure
View Answer
B
Q19: Which of the following is true about flat file databases?
- A: They are ideal for storing complex relationships
- B: They often lead to data redundancy
- C: They are highly reliable
- D: They are used for large-scale systems
View Answer
B
Q20: How are rows in a flat file database separated?
- A: By semicolons
- B: By commas or tabs
- C: By spaces
- D: By slashes
View Answer
B