MCQs on DFDs, Data Modeling, SDLC, Data Dictionaries & More
1. What is the main difference between a Level 0 DFD and a Level 1 DFD?
A) Level 0 includes detailed processes
B) Level 1 contains external entities
C) Level 1 breaks down the single process of Level 0 into subprocesses
D) Level 0 shows internal data stores
Answer: C
2. Why is process numbering important in DFDs?
A) To define data storage
B) To ensure consistency and track subprocesses
C) To calculate data volume
D) To identify users
Answer: B
3. Which symbol is used for data stores in a DFD?
A) Oval
B) Arrow
C) Double vertical lines or open-ended rectangle
D) Circle
Answer: C
4. A passive data dictionary is:
A) Automatically updated with system changes
B) Integrated with the DBMS
C) Manually maintained and not linked to the database
D) Used for data recovery only
Answer: C
5. Which type of data dictionary provides better real-time data tracking?
A) Passive
B) Manual
C) Static
D) Active
Answer: D
6. Why are integrated systems better in performance?
A) They reduce electricity usage
B) They remove all external users
C) They allow for faster access and reduce redundancy
D) They use more hardware
Answer: C
7. The main purpose of a cross reference matrix is to:
A) Encrypt data
B) Track user activity
C) Show relationships between elements like processes and data stores
D) Sort files alphabetically
Answer: C
8. What does the cross reference matrix help in identifying?
A) Data types
B) CPU performance
C) Process-data relationships
D) System errors
Answer: C
9. What is the first phase in the System Development Life Cycle (SDLC)?
A) Design
B) Testing
C) Preliminary Investigation
D) Implementation
Answer: C
10. What is the output of the Analysis phase in SDLC?
A) Feasibility Report
B) Database Table
C) Requirements Specification Document
D) System Code
Answer: C
11. Which of the following is *not* a component of a data model?
A) Data structure
B) Integrity constraints
C) Presentation layer
D) Manipulation language
Answer: C
12. What is the purpose of integrity constraints in a data model?
A) Speed up the processor
B) Prevent invalid data entries
C) Optimize power consumption
D) Control software installation
Answer: B
13. Which of these best explains the importance of data modeling?
A) It helps with social media performance
B) It creates marketing plans
C) It serves as a blueprint for designing a logical and physical database
D) It defines website layout
Answer: C
14. In data modeling, what does the manipulation language component do?
A) Draws DFDs
B) Describes how data is accessed and modified
C) Sets up firewalls
D) Runs antivirus scans
Answer: B
15. In DFDs, external entities are represented by which symbol?
A) Square
B) Arrow
C) Double circle
D) Diamond
Answer: A