Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 5
Q61:
What is the purpose of the Preliminary Study phase?
A. To analyze user environment
B. To create physical design of the database
C. To study system and information flow
D. To implement DBMS
Correct Answer:
C
Chapter: 5
Q62:
Which tool is most commonly used for designing database systems?
A. ER Diagrams
B. Data Flow Diagrams (DFD)
C. Class Diagrams
D. Flowcharts
Correct Answer:
B
Chapter: 5
Q63:
Data stores in DFDs are represented by which symbol?
A. Oval
B. Rectangle with open sides
C. Rectangle with double lines
D. Arrows
Correct Answer:
C
Chapter: 5
Q64:
Processes in Data Flow Diagrams are represented by which symbol?
A. Rectangle
B. Arrow
C. Oval or Rounded Rectangle
D. Circle
Correct Answer:
C
Chapter: 5
Q65:
Which phase involves writing application programs according to user requirements?
A. Physical Design
B. Implementation
C. Database Design
D. Maintenance
Correct Answer:
B
Chapter: 5
Q66:
What is the last step in the database development process?
A. Preliminary Study
B. Requirement Analysis
C. Maintenance of Database System
D. Implementation
Correct Answer:
C
Chapter: 5
Q67:
What is a context diagram?
A. A detailed system diagram
B. A simple diagram showing system context
C. A level 1 diagram
D. A physical model
Correct Answer:
B
Chapter: 5
Q68:
Which phase of database development involves identifying entities and relationships?
A. Database Design
B. Requirement Analysis
C. Physical Design
D. Implementation
Correct Answer:
A
Chapter: 5
Q69:
What does the AND operator in DFD represent?
A. Data flows to one sink
B. Data flows to all sinks
C. Data is stored
D. Data is transformed
Correct Answer:
B
Chapter: 5
Q70:
What does a separator symbol in DFDs represent?
A. Data flows from one source to multiple sinks
B. Data flows to a single source
C. Data is transformed
D. Data is stored
Correct Answer:
A
Chapter: 5
Q71:
In DFDs, what does the Ring Sum Operator signify?
A. Data flows to all sinks
B. Data flows to one of the mentioned sinks
C. Data flows to multiple sources
D. Data flows in parallel
Correct Answer:
B
Chapter: 5
Q72:
Which diagram level provides the least amount of detail in a DFD?
A. Level 0
B. Detailed Diagram
C. Context Diagram
D. Conceptual Model
Correct Answer:
C
Chapter: 5
Q73:
Database design and application design happen in ______.
A. Sequence
B. Parallel
C. Completely independent steps
D. After maintenance
Correct Answer:
B
Chapter: 5
Q74:
Which symbol is used to represent external entities in DFDs?
A. Circle
B. Rounded Rectangle
C. Rectangle
D. Arrow
Correct Answer:
C
Chapter: 5
Q75:
_________ helps identify interactions between sections of an organization in the Preliminary Study phase.
A. Data Flow Diagrams
B. Requirement Analysis
C. Entity Relationship Models
D. Maintenance Phases
Correct Answer:
A
Chapter: 5
Q76:
What is the function of the collector symbol in DFDs?
A. Collects multiple dataflows
B. Separates dataflows
C. Converts data to a process
D. Stores data for future use
Correct Answer:
A
Chapter: 5
Q77:
What type of diagram shows only input/output from a system and external entities?
A. Context Diagram
B. Level 0 Diagram
C. Detailed Diagram
D. Physical Design Diagram
Correct Answer:
A
Chapter: 5
Q78:
Physical design is based on _______.
A. Application programs
B. Logical design
C. Requirement analysis
D. Data flow diagrams
Correct Answer:
B
Chapter: 5
Q79:
Which of the following is a limitation of DFDs?
A. Cannot express data flow
B. Cannot express decision points
C. Cannot express external entities
D. Cannot express data stores
Correct Answer:
B
Chapter: 5
Q80:
Dataflow in DFDs is represented by ______.
A. Circles
B. Arrows
C. Rectangles
D. Double Lines
Correct Answer:
B