Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
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
View Answer
C
Q62: Which tool is most commonly used for designing database systems?
- A: ER Diagrams
- B: Data Flow Diagrams (DFD)
- C: Class Diagrams
- D: Flowcharts
View Answer
B
Q63: Data stores in DFDs are represented by which symbol?
- A: Oval
- B: Rectangle with open sides
- C: Rectangle with double lines
- D: Arrows
View Answer
C
Q64: Processes in Data Flow Diagrams are represented by which symbol?
- A: Rectangle
- B: Arrow
- C: Oval or Rounded Rectangle
- D: Circle
View Answer
C
Q65: Which phase involves writing application programs according to user requirements?
- A: Physical Design
- B: Implementation
- C: Database Design
- D: Maintenance
View Answer
B
Q66: What is the last step in the database development process?
- A: Preliminary Study
- B: Requirement Analysis
- C: Maintenance of Database System
- D: Implementation
View Answer
C
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
View Answer
B
Q68: Which phase of database development involves identifying entities and relationships?
- A: Database Design
- B: Requirement Analysis
- C: Physical Design
- D: Implementation
View Answer
A
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
View Answer
B
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
View Answer
A