Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 6
Q81:
What is the primary goal of the requirement gathering process?
A. Identify system design
B. Communicate requirements
C. Develop the final system
D. Schedule system updates
Correct Answer:
B
Chapter: 6
Q82:
Which of the following is a major challenge in requirement gathering?
A. User feedback
B. Changing technology
C. Missing requirements
D. Rapid prototyping
Correct Answer:
C
Chapter: 6
Q83:
What is a verifiable requirement?
A. A requirement that is complete
B. A requirement that is testable
C. A requirement that is clear
D. A requirement that is traceable
Correct Answer:
B
Chapter: 6
Q84:
What is an example of an incomplete requirement?
A. Loading time must be as minimum as possible
B. Loading time should be 2 seconds
C. System backup should support 30 minutes
D. System should support 24/7 operations
Correct Answer:
A
Chapter: 6
Q85:
A requirement is consistent if it:
A. Does not conflict with other requirements
B. Includes user feedback
C. Can be tested with a prototype
D. Is agreed upon by all stakeholders
Correct Answer:
A
Chapter: 6
Q86:
What is an example of a traceable requirement?
A. System must generate a unique batch report
B. System must load within 2 seconds
C. System must support normal operations
D. System must allow for user customization
Correct Answer:
A
Chapter: 6
Q87:
Requirement engineering acts as a bridge between which two entities?
A. Users and software
B. Customers and system development
C. Real-world needs and system capabilities
D. Software and hardware
Correct Answer:
C
Chapter: 6
Q88:
Requirements engineering consists of which two main processes?
A. Requirement specification and validation
B. Requirement gathering and analysis
C. Requirement management and development
D. Requirement elicitation and specification
Correct Answer:
C
Chapter: 6
Q89:
The process of analyzing the impact of requirement changes is part of which discipline?
A. Requirement Elicitation
B. Requirement Specification
C. Requirement Development
D. Requirement Management
Correct Answer:
D
Chapter: 6
Q90:
Which of the following techniques is commonly used in requirement elicitation?
A. Interview
B. Code review
C. Debugging
D. Unit testing
Correct Answer:
A
Chapter: 6
Q91:
Requirement prioritization helps in which aspect of system development?
A. Scheduling the development phases
B. Minimizing project scope
C. Creating a test plan
D. Coding efficiency
Correct Answer:
A
Chapter: 6
Q92:
What does "user friendliness" in software development refer to?
A. Ease of installation
B. Technical documentation
C. Ease of use and learnability
D. Code readability
Correct Answer:
C
Chapter: 6
Q93:
An example of reliability as a quality metric is:
A. System fails after every 1000 transactions
B. System performs without failure for 100,000 transactions
C. System can handle only low volume
D. System crashes frequently
Correct Answer:
B
Chapter: 6
Q94:
What is the focus of non-functional requirements in system development?
A. Defining system behaviors
B. Defining what the system should do
C. Ensuring customer satisfaction
D. Defining how the system should operate
Correct Answer:
D
Chapter: 6
Q95:
Which of the following is an example of requirement management?
A. Coordinating requirement elicitation and analysis
B. Debugging code
C. Creating unit tests
D. Writing technical documentation
Correct Answer:
A
Chapter: 6
Q96:
What is the purpose of requirement specification?
A. To outline the system functionality
B. To prioritize tasks
C. To establish a contract between client and developer
D. To create a test plan
Correct Answer:
C
Chapter: 6
Q97:
The process of turning gathered requirements into a specification is part of which activity?
A. Requirement Elicitation
B. Requirement Analysis
C. Requirement Development
D. Requirement Testing
Correct Answer:
C
Chapter: 6
Q98:
In project management, why is user involvement crucial?
A. It helps define requirements
B. It speeds up development
C. It minimizes errors
D. It eliminates the need for testing
Correct Answer:
A
Chapter: 6
Q99:
Fill in the blank: Requirement _________ is the process of gathering and turning requirements into a specification.
A. elicitation
B. specification
C. development
D. management
Correct Answer:
A
Chapter: 7
Q100:
What is the primary unit of data in a relational database?
A. Table
B. Tuple (row)
C. Column
D. Field
Correct Answer:
B