1. Which of the following best describes a DBMS?
A. A collection of unrelated files
B. A software that manages databases
C. A programming language
D. A type of hardware
Answer: B
Explanation: DBMS is software used to create, manage, and manipulate databases.
2. Which of the following is NOT an advantage of DBMS?
A. Data redundancy control
B. Improved data sharing
C. Data inconsistency
D. Backup and recovery
Answer: C
Explanation: DBMS reduces inconsistency; it is not an advantage.
3. A database is a collection of ______.
A. Programs
B. Interrelated data
C. Instructions
D. Hardware devices
Answer: B
Explanation: A database stores logically related and organized data.
4. DBMS acts as an interface between ______.
A. User and operating system
B. Data and database
C. User and database
D. Application and hardware
Answer: C
Explanation: DBMS helps users interact with data stored in databases.
5. Which architecture has a client and a server?
A. 1-tier
B. 2-tier
C. 3-tier
D. 4-tier
Answer: B
Explanation: 2-tier architecture includes client and database server.
6. Which is NOT a type of DBMS?
A. Relational
B. Network
C. Hierarchical
D. Mechanical
Answer: D
Explanation: Mechanical is not a DBMS model.
7. In 3-tier architecture, which layer is responsible for business logic?
A. Presentation layer
B. Application layer
C. Data layer
D. Storage layer
Answer: B
Explanation: The middle-tier handles application/business logic
8. Which level of abstraction describes how data is actually stored?
A. Physical level
B. Logical level
C. View level
D. Conceptual level
Answer: A
Explanation: Physical level deals with storage details.
9. Which level provides data independence?
A. Physical
B. Logical
C. Conceptual
D. Internal
Answer: B
Explanation: Logical level hides physical storage details.
10. Data independence refers to ______.
A. Independence from hardware
B. Modifying the schema at one level without affecting other levels
C. Data stored without duplication
D. Data stored independently in each table
Answer: B
Explanation: Data independence isolates changes across layers.
11. Which of the following uses tables to store data?
A. Hierarchical DBMS
B. Network DBMS
C. Relational DBMS
D. Object-oriented DBMS
Answer: C
Explanation: RDBMS stores data in rows and columns.
12. Which of these provides multiple views of data?
A. File system
B. DBMS
C. Compiler
D. Operating system
Answer: B
Explanation: DBMS enables different user views of the same data.
13. The main disadvantage of the file system is ______.
A. Data consistency
B. Data security
C. Data redundancy
D. Data sharing
Answer: C
Explanation: File systems have lots of redundant data.
14. Metadata means ______.
A. Data about data
B. Very large data
C. Important data
D. Program code
Answer: A
Explanation: Metadata describes structure and properties of data.
15. Which is a basic function of a DBMS?
A. Network routing
B. Data manipulation
C. Web designing
D. Application debugging
Answer: B
Explanation: DBMS allows inserting, updating, and retrieving data.
16. Which component manages DBMS execution?
A. Query processor
B. Storage manager
C. DML compiler
D. DDL interpreter
Answer: A
Explanation: Query processor interprets and executes queries.
17. Which ensures durability after a system crash?
A. Failure log
B. Recovery manager
C. Data dictionary
D. Metadata
Answer: B
Explanation: Recovery manager restores data after failures.
18. Which ensures that only authorized users access data?
A. DML compiler
B. Authorization manager
C. Recovery manager
D. Query processor
Answer: B
Explanation: Authorization manager enforces access control.
19. Which of the following is part of the DBMS environment?
A. Users
B. Database
C. Application programs
D. All of these
Answer: D
Explanation: DBMS environment includes users, database, and programs.
20. A DBMS that stores objects is called ______.
A. Object-oriented DBMS
B. Relational DBMS
C. Flat DBMS
D. Hierarchical DBMS
Answer: A
Explanation: OODBMS stores data in objects
21. Which is NOT a user of a DBMS?
A. Database administrator
B. End user
C. System analyst
D. Compiler
Answer: D
Explanation: Compiler is unrelated to database usage.
22. DBA stands for ______.
A. Database Advisor
B. Data Basic Administrator
C. Database Administrator
D. Data Backup Agent
Answer: C
Explanation: DBA manages and maintains the database.
23. The file system cannot handle ______.
A. Long-term storage
B. Concurrent access
C. File creation
D. File deletion
Answer: B
Explanation: File systems fail in concurrent multi-user environments.
24. Which of these is NOT a responsibility of DBA?
A. Schema definition
B. Backup and recovery
C. Query writing for clients
D. Performance tuning
Answer: C
Explanation: DBAs don’t usually write client queries.
25. DBMS reduces data redundancy by ______.
A. Creating duplicate files
B. Storing data once in a centralized location
C. Removing all data fields
D. Denormalization
Answer: B
Explanation: Centralized storage minimizes redundancy.