Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q31: How is a user's Date of Birth typically stored in a database?
- A: dd-mm-yyyy
- B: mm-dd-yyyy
- C: month-day-year
- D: yyyy/mm/dd
View Answer
A
Q32: The Internal Level schema of a database is responsible for defining:
- A: Data structures and storage
- B: User permissions
- C: External view generation
- D: Security policies
View Answer
A
Q33: What happens when the internal structure of a database is changed?
- A: Affects only one record
- B: Impacts all stored records
- C: Changes only the external view
- D: No effect on the database
View Answer
B
Q34: Fill in the blank: The ______ schema is the complete description of all data stored in the database and manages the relationships among entities.
- A: external
- B: conceptual
- C: internal
- D: logical
View Answer
B
Q35: Fill in the blank: If a user's view needs to be changed without altering the internal schema, the change is made at the ______ level.
- A: external
- B: internal
- C: conceptual
- D: schema
View Answer
A
Q36: Which of the following is an example of data stored at the conceptual level?
- A: User interface settings
- B: Stored procedures
- C: Definitions of all entities and relationships
- D: File system paths
View Answer
C
Q37: Fill in the blank: The ______ architecture ensures that the physical representation of data is separated from how users view the data.
- A: conceptual
- B: internal
- C: external
- D: Three-Level Schema
View Answer
D
Q38: What is the internal schema responsible for in a DBMS?
- A: Logical structure
- B: Data storage on media
- C: User interaction
- D: Backup services
View Answer
B
Q39: Data independence is a key feature of which architecture?
- A: File System
- B: Client-Server
- C: 3-Level Database
- D: Hierarchical
View Answer
C
Q40: Which type of data is typically stored in binary format in a DBMS?
- A: Text data
- B: Numeric data
- C: Data of any format
- D: Image data
View Answer
C