Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q71: If a customer rents multiple building types, how many contracts are assigned?
- A: One contract for all buildings
- B: Separate contracts for each building
- C: No contract is assigned
- D: Only one bill is generated without contracts
View Answer
B
Q72: What types of data are stored about customers in the rental system?
- A: Name and address
- B: Name, phone, and address
- C: Phone number only
- D: Contract number only
View Answer
B
Q73: In the restaurant system, what is the price range of food offered per person?
- A: 500-1000
- B: 700-1200
- C: 1000-1500
- D: 1200-1500
View Answer
B
Q74: The cost of each dish in the restaurant system is calculated based on ________.
- A: ingredients only
- B: ingredients and electricity
- C: ingredients plus profit
- D: ingredient and labor cost
View Answer
A
Q75: What is the percentage of profit added in the restaurant system?
- A: 0.1
- B: 0.15
- C: 0.2
- D: 0.05
View Answer
C
Q76: Ingredients and quantity are mentioned in the ________ of the restaurant system.
- A: Menu
- B: Recipe
- C: Restaurant manual
- D: Inventory
View Answer
B
Q77: Which of the following is NOT considered when defining the system from requirements?
- A: Performance
- B: Legal issues
- C: Database size
- D: Branding
View Answer
D
Q78: In system definition, the system is further divided into ________ to fulfill requirements.
- A: processes
- B: subsystems
- C: departments
- D: modules
View Answer
B
Q79: The initial database size is part of which step in system definition?
- A: Database design
- B: Fact finding
- C: System definition
- D: Requirement writing
View Answer
C
Q80: System definition is based on which of the following?
- A: Random interviews
- B: Stakeholder needs and expectations
- C: Software testing
- D: User interface design
View Answer
B