Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 5
Q81:
In database design, entities are given _______.
A. Constraints
B. Attributes
C. Processes
D. Operators
Correct Answer:
B
Chapter: 5
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
Correct Answer:
A
Chapter: 6
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
Correct Answer:
B
Chapter: 6
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
Correct Answer:
C
Chapter: 6
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.
Correct Answer:
A
Chapter: 6
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
Correct Answer:
B
Chapter: 6
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
Correct Answer:
A
Chapter: 6
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
Correct Answer:
C
Chapter: 6
Q89:
A free-standing data dictionary is typically created using what?
A. DBMS internal tools
B. CASE tools
C. Manual processes
D. SQL queries
Correct Answer:
B
Chapter: 6
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
Correct Answer:
A
Chapter: 6
Q91:
In the database design phase, what type of data model is often used to create a conceptual design?
A. Relational data model
B. ER-Data model
C. Network data model
D. Hierarchical data model
Correct Answer:
B
Chapter: 6
Q92:
What is the purpose of a cross-reference matrix in database design?
A. To map database objects to physical servers
B. To help identify the relationships between database entities and reports
C. To track database performance
D. To generate SQL queries
Correct Answer:
B
Chapter: 6
Q93:
Which type of database design uses a specific DBMS for logical implementation?
A. Conceptual database design
B. Physical database design
C. Logical database design
D. None of the above
Correct Answer:
C
Chapter: 6
Q94:
What is a Record-Based Data Model used for?
A. Defining abstract data types
B. Designing user interfaces
C. Managing records at all three levels of database architecture
D. None of the above
Correct Answer:
C
Chapter: 6
Q95:
Which of the following is NOT a type of Record-Based Data Model?
A. Hierarchical data model
B. Network data model
C. Relational data model
D. ER-Data model
Correct Answer:
D
Chapter: 6
Q96:
What is the key advantage of separating conceptual, logical, and physical database designs?
A. Improved system speed
B. Simplified user access
C. Enhanced abstraction and flexibility
D. Reduced data storage
Correct Answer:
C
Chapter: 7
Q97:
What is the E-R data model used for?
A. Logical operations
B. Physical data storage
C. Graphical representation of conceptual database design
D. Simplifying code logic
Correct Answer:
C
Chapter: 7
Q98:
Which data model is more expressive for designing a conceptual database?
A. Hierarchical
B. Network
C. Semantic
D. Relational
Correct Answer:
C
Chapter: 7
Q99:
What type of data model is the E-R data model?
A. Physical
B. Semantic
C. Conceptual
D. Relational
Correct Answer:
B
Chapter: 7
Q100:
In the E-R data model, what is the basic building block?
A. Attribute
B. Relationship
C. Entity
D. Database
Correct Answer:
C