Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 4
Q61:
Free-format questions in a questionnaire are more ________ in nature.
A. Specific
B. Subjective
C. Objective
D. Tabulated
Correct Answer:
B
Chapter: 4
Q62:
Structured interviews are divided into two categories: ________.
A. Free-format and fixed-format
B. Structured and unstructured
C. Open-ended and close-ended
D. Tabulated and un-tabulated
Correct Answer:
C
Chapter: 4
Q63:
In the process of observation, why is it important to know peak periods?
A. To better understand system operations
B. To ask more questions
C. To verify facts
D. To collect feedback
Correct Answer:
A
Chapter: 4
Q64:
Conducting interviews helps the analyst to ________.
A. Analyze documents
B. Gather diverse ideas
C. Handle large data sets
D. Conduct research
Correct Answer:
B
Chapter: 5
Q65:
What is the next step after fact finding in database design and development?
A. Coding
B. Requirement writing
C. Testing
D. Data modeling
Correct Answer:
B
Chapter: 5
Q66:
The requirement document describes which of the following?
A. Only system processes
B. Only data flows
C. Data and relationships
D. Hardware specifications
Correct Answer:
C
Chapter: 5
Q67:
How many types of buildings are there in the rental system?
A. 2
B. 3
C. 4
D. 5
Correct Answer:
B
Chapter: 5
Q68:
What is the total number of floors in the plaza?
A. 5
B. 6
C. 7
D. 4
Correct Answer:
B
Chapter: 5
Q69:
In the rental system, which type of buildings are found on 3 floors?
A. Shops
B. Apartments
C. Offices
D. Both apartments and shops
Correct Answer:
B
Chapter: 5
Q70:
Rent bills in the rental system are generated every ________.
A. month
B. two months
C. week
D. quarter
Correct Answer:
B
Chapter: 5
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
Correct Answer:
B
Chapter: 5
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
Correct Answer:
B
Chapter: 5
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
Correct Answer:
B
Chapter: 5
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
Correct Answer:
A
Chapter: 5
Q75:
What is the percentage of profit added in the restaurant system?
A. 0.1
B. 0.15
C. 0.2
D. 0.05
Correct Answer:
C
Chapter: 5
Q76:
Ingredients and quantity are mentioned in the ________ of the restaurant system.
A. Menu
B. Recipe
C. Restaurant manual
D. Inventory
Correct Answer:
B
Chapter: 5
Q77:
Which of the following is NOT considered when defining the system from requirements?
A. Performance
B. Legal issues
C. Database size
D. Branding
Correct Answer:
D
Chapter: 5
Q78:
In system definition, the system is further divided into ________ to fulfill requirements.
A. processes
B. subsystems
C. departments
D. modules
Correct Answer:
B
Chapter: 5
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
Correct Answer:
C
Chapter: 5
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
Correct Answer:
B