Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 2
Q21:
What does data inconsistency lead to?
A. Improved data quality
B. Loss of information
C. Enhanced data retrieval
D. Faster database performance
Correct Answer:
B
Chapter: 2
Q22:
Which of the following best describes ‘Meta Data’?
A. Raw facts collected for analysis
B. Data related to real-world objects
C. Schema for describing data storage and attributes
D. Actual data stored in a database
Correct Answer:
C
Chapter: 2
Q23:
Who is responsible for database backups and recovery?
A. Application Programmer
B. Naïve User
C. Database Administrator (DBA)
D. Sophisticated User
Correct Answer:
C
Chapter: 2
Q24:
What is meant by concurrency control in a database system?
A. Accessing the database only once a day
B. Multiple users accessing the database simultaneously without conflicts
C. Ensuring data is deleted after use
D. Granting user permissions
Correct Answer:
B
Chapter: 2
Q25:
Which of the following is a cost involved in adopting a database system?
A. Faster access to data
B. High software and hardware costs
C. Lower data security
D. Faster application development
Correct Answer:
B
Chapter: 3
Q26:
What is the key benefit of standardization in database systems?
A. Faster data retrieval
B. Easier system development
C. Enhanced security
D. Improved visualization
Correct Answer:
B
Chapter: 3
Q27:
Which of the following is the most popular database standard proposed in 1975?
A. ANSI SPARK
B. ISO SQL
C. Oracle DB
D. Microsoft Access
Correct Answer:
A
Chapter: 3
Q28:
What does the Three-Level Schema architecture primarily achieve?
A. Data redundancy
B. Simplifying physical data storage
C. Separation of physical data and user views
D. Data encryption
Correct Answer:
C
Chapter: 3
Q29:
Which of the following is an example of a conceptual schema?
A. User login details
B. Salesperson data linked to customers and outlets
C. Customer phone numbers
D. Product price changes
Correct Answer:
B
Chapter: 3
Q30:
In the Three-Level Schema, which view presents data in user-required formats?
A. Internal View
B. Conceptual View
C. External View
D. Logical View
Correct Answer:
C
Chapter: 3
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
Correct Answer:
A
Chapter: 3
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
Correct Answer:
A
Chapter: 3
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
Correct Answer:
B
Chapter: 3
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
Correct Answer:
B
Chapter: 3
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
Correct Answer:
A
Chapter: 3
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
Correct Answer:
C
Chapter: 3
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
Correct Answer:
D
Chapter: 4
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
Correct Answer:
B
Chapter: 4
Q39:
Data independence is a key feature of which architecture?
A. File System
B. Client-Server
C. 3-Level Database
D. Hierarchical
Correct Answer:
C
Chapter: 4
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
Correct Answer:
C