Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 4
Q41:
Which of the following is added to the data by the DBMS when storing it?
A. Indexes
B. Physical addresses
C. File paths
D. Permissions
Correct Answer:
A
Chapter: 4
Q42:
Which process reduces disk operations and improves the efficiency of writing data?
A. Record header addition
B. Data compression
C. Block-wise storage
D. File organization
Correct Answer:
C
Chapter: 4
Q43:
The mapping between internal and conceptual levels is called?
A. Conceptual mapping
B. External mapping
C. Conceptual/Internal mapping
D. External/Internal mapping
Correct Answer:
C
Chapter: 4
Q44:
What is data encryption used for at the internal level?
A. Reduce storage space
B. Improve data readability
C. Secure stored data
D. Create indexes
Correct Answer:
C
Chapter: 4
Q45:
What is the DBMS responsible for in a client-server environment?
A. Data input
B. Transaction processing
C. Communication
D. Storing files
Correct Answer:
B
Chapter: 4
Q46:
Which type of independence is achieved between the conceptual and internal levels?
A. Physical data independence
B. Logical data independence
C. Data communication independence
D. Transaction independence
Correct Answer:
A
Chapter: 4
Q47:
What does the DBMS catalog store?
A. Physical locations of data
B. Schema information
C. Data encryption keys
D. Backup information
Correct Answer:
B
Chapter: 4
Q48:
Logical data independence protects changes made at which level?
A. Physical
B. Conceptual
C. External
D. Data storage
Correct Answer:
B
Chapter: 4
Q49:
What function allows multiple transactions to be processed simultaneously?
A. Transaction support
B. Concurrency control
C. Authorization services
D. Recovery services
Correct Answer:
B
Chapter: 4
Q50:
What does data integrity ensure in a DBMS?
A. Data is stored in binary format
B. Data reflects the truth
C. Data is compressed
D. Data is encrypted
Correct Answer:
B
Chapter: 4
Q51:
A Single User DBMS is also known as?
A. File Server
B. Desktop Database
C. Teleprocessing System
D. Client-Server Database
Correct Answer:
B
Chapter: 4
Q52:
In a multi-user DBMS, teleprocessing is now considered?
A. Most advanced
B. Legacy system
C. Highly efficient
D. Secure
Correct Answer:
B
Chapter: 4
Q53:
Which DBMS function ensures only authorized users can access data?
A. Transaction support
B. Authorization services
C. Recovery services
D. Concurrency control
Correct Answer:
B
Chapter: 4
Q54:
Which method reduces storage space without compromising retrieval performance?
A. Indexing
B. Data mapping
C. Data compression
D. File organization
Correct Answer:
C
Chapter: 4
Q55:
Which service ensures that lost data can be recovered in case of failure?
A. Integrity services
B. Recovery services
C. Data processing
D. Transaction support
Correct Answer:
B
Chapter: 4
Q56:
Which independence ensures that changes at the internal level do not affect the conceptual level?
A. Data Communication
B. Logical Data Independence
C. Physical Data Independence
D. Transaction Support
Correct Answer:
C
Chapter: 5
Q57:
What is the most important phase in database application development?
A. Application Programs
B. Database Design
C. Maintenance of Database System
D. Implementation
Correct Answer:
B
Chapter: 5
Q58:
Which of the following is the first phase of database development?
A. Preliminary Study
B. Requirement Analysis
C. Physical Design
D. Maintenance
Correct Answer:
A
Chapter: 5
Q59:
In which phase are schemas for the database created?
A. Requirement Analysis
B. Database Design
C. Physical Design
D. Implementation
Correct Answer:
B
Chapter: 5
Q60:
When is the logical design of the database transformed into physical design?
A. During Database Design
B. During Requirement Analysis
C. During Physical Design
D. During Implementation
Correct Answer:
C