Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 1
Q1:
What is data often referred to as?
A. Processed information
B. Raw material for analysis
C. Decision-making tool
D. Optimized information
Correct Answer:
B
Chapter: 1
Q2:
What is the main difference between data and information?
A. Data is processed
B. Data is raw, and information is processed
C. Information is unstructured
D. Information is unrelated to data
Correct Answer:
B
Chapter: 1
Q3:
A telephone directory with names, telephone numbers, and addresses is an example of:
A. Information
B. A decision-making tool
C. Data
D. A database
Correct Answer:
C
Chapter: 1
Q4:
Data becomes information when it is:
A. Organized and analyzed
B. Collected
C. Randomly stored
D. Removed from a database
Correct Answer:
A
Chapter: 1
Q5:
Which of the following is an example of data becoming information?
A. A list of students with CGPA > 3
B. A raw file of student records
C. A collection of books
D. A telephone directory
Correct Answer:
A
Chapter: 1
Q6:
What is the relationship between data and information?
A. Information leads to data
B. Data is a subset of information
C. Information is a subset of data
D. They are the same
Correct Answer:
C
Chapter: 1
Q7:
What happens to data when it is processed for a specific purpose?
A. It becomes information
B. It gets deleted
C. It turns into a database
D. It is stored randomly
Correct Answer:
A
Chapter: 1
Q8:
Which of the following statements is TRUE about databases?
A. Databases store information
B. Databases only handle small sets of data
C. Databases optimize data storage
D. Databases are manual processes
Correct Answer:
C
Chapter: 1
Q9:
A database management system (DBMS) is a tool that helps with:
A. Data collection
B. Data manipulation and retrieval
C. Decision making
D. None of the above
Correct Answer:
B
Chapter: 1
Q10:
What is the main function of a DBMS?
A. Design databases
B. Create unorganized data
C. Manage data retrieval and manipulation
D. Store raw data
Correct Answer:
C
Chapter: 1
Q11:
Which of the following is an example of a DBMS?
A. Student record
B. Oracle
C. Microsoft Excel
D. Telephone directory
Correct Answer:
B
Chapter: 1
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
Correct Answer:
B
Chapter: 1
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
Correct Answer:
A
Chapter: 2
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
Correct Answer:
A
Chapter: 2
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
Correct Answer:
B
Chapter: 2
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
Correct Answer:
B
Chapter: 2
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
Correct Answer:
A
Chapter: 2
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
Correct Answer:
B
Chapter: 2
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
Correct Answer:
B
Chapter: 2
Q20:
How are rows in a flat file database separated?
A. By semicolons
B. By commas or tabs
C. By spaces
D. By slashes
Correct Answer:
B