Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q51: A Single User DBMS is also known as?
- A: File Server
- B: Desktop Database
- C: Teleprocessing System
- D: Client-Server Database
View Answer
B
Q52: In a multi-user DBMS, teleprocessing is now considered?
- A: Most advanced
- B: Legacy system
- C: Highly efficient
- D: Secure
View Answer
B
Q53: Which DBMS function ensures only authorized users can access data?
- A: Transaction support
- B: Authorization services
- C: Recovery services
- D: Concurrency control
View Answer
B
Q54: Which method reduces storage space without compromising retrieval performance?
- A: Indexing
- B: Data mapping
- C: Data compression
- D: File organization
View Answer
C
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
View Answer
B
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
View Answer
C
Q57: What is the most important phase in database application development?
- A: Application Programs
- B: Database Design
- C: Maintenance of Database System
- D: Implementation
View Answer
B
Q58: Which of the following is the first phase of database development?
- A: Preliminary Study
- B: Requirement Analysis
- C: Physical Design
- D: Maintenance
View Answer
A
Q59: In which phase are schemas for the database created?
- A: Requirement Analysis
- B: Database Design
- C: Physical Design
- D: Implementation
View Answer
B
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
View Answer
C