Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
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
View Answer
B
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
View Answer
C
Q73: Database design and application design happen in ______.
- A: Sequence
- B: Parallel
- C: Completely independent steps
- D: After maintenance
View Answer
B
Q74: Which symbol is used to represent external entities in DFDs?
- A: Circle
- B: Rounded Rectangle
- C: Rectangle
- D: Arrow
View Answer
C
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
View Answer
A
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
View Answer
A
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
View Answer
A
Q78: Physical design is based on _______.
- A: Application programs
- B: Logical design
- C: Requirement analysis
- D: Data flow diagrams
View Answer
B
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
View Answer
B
Q80: Dataflow in DFDs is represented by ______.
- A: Circles
- B: Arrows
- C: Rectangles
- D: Double Lines
View Answer
B