Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q81: In database design, entities are given _______.
- A: Constraints
- B: Attributes
- C: Processes
- D: Operators
View Answer
B
Q82: When transforming logical design into physical design, which of the following is a key decision?
- A: Choosing data types
- B: Defining attributes
- C: Mapping entities
- D: Developing conceptual models
View Answer
A
Q83: What is the purpose of a Detailed Data Flow Diagram (DFD)?
- A: To define the overall system
- B: To provide additional details to a Level 0 DFD
- C: To outline hardware components
- D: To design a database schema
View Answer
B
Q84: In a detailed DFD, the processes are numbered based on what?
- A: Their complexity
- B: The level of detail required
- C: The process numbering in the Level 0 DFD
- D: The number of inputs
View Answer
C
Q85: How are sub-processes numbered in a detailed DFD for process 1.0?
- A: 1.1, 1.2, 1.3, etc.
- B: 2.1, 2.2, 2.3, etc.
- C: 1.0.1, 1.0.2, 1.0.3, etc.
- D: 0.1, 0.2, 0.3, etc.
View Answer
A
Q86: What is the recommended maximum number of processes in a detailed DFD?
- A: 5
- B: 7 to 9
- C: 10 to 15
- D: 15 to 20
View Answer
B
Q87: What is the role of a Data Dictionary in a database system?
- A: It contains metadata about the databases
- B: It stores user passwords
- C: It manages file permissions
- D: It defines the hardware configuration
View Answer
A
Q88: Which type of data dictionary is embedded in the DBMS itself?
- A: Free-standing data dictionary
- B: External data dictionary
- C: Integrated data dictionary
- D: Case tool dictionary
View Answer
C
Q89: A free-standing data dictionary is typically created using what?
- A: DBMS internal tools
- B: CASE tools
- C: Manual processes
- D: SQL queries
View Answer
B
Q90: In a cross-reference matrix, what is typically listed on the Y-axis?
- A: Database attributes
- B: Reports and transactions
- C: Database objects
- D: Database schema
View Answer
A