DATABASE MANAGEMENT SYSTEMS EXAM
1 LATEST UPDATE 2026 QUESTIONS WITH
CORRECT ANSWERS PLUS RATIONALES |
GRADED A
1. What is a Database?
Answer: A structured collection of related data
Rationale: Databases store data in an organized way to allow efficient access and management.
2. A DBMS is best described as:
A. A programming language
B. A file system
C. Software for managing databases
D. A hardware device
Answer: C
Rationale: A DBMS is software that creates, manages, and controls access to databases.
3. Which of the following is NOT a function of a DBMS?
A. Data storage
B. Data security
C. Data redundancy increase
D. Data retrieval
Answer: C
Rationale: DBMSs aim to reduce, not increase, redundancy.
4. Example of a DBMS:
A. Microsoft Word
B. Oracle
C. Linux
D. Python
Answer: B
Rationale: Oracle is a relational DBMS.
,5. Which is NOT a database application?
A. Banking system
B. Airline reservation
C. Payroll system
D. Text editor
Answer: D
Rationale: Text editors don’t manage structured databases.
6. The main goal of a DBMS is to:
Answer: Provide efficient and secure data access
Rationale: Efficiency, security, and consistency are core DBMS goals.
7. Data in a database is usually:
Answer: Logically related
Rationale: Databases store related data, not random files.
8. DBMS allows multiple users to:
Answer: Access data concurrently
Rationale: Concurrency control is a key DBMS feature.
9. Which term refers to unnecessary duplication of data?
Answer: Data redundancy
Rationale: Redundancy leads to inconsistency and wasted storage.
10. Which problem occurs when redundant data is updated inconsistently?
Answer: Data inconsistency
Rationale: Different copies of the same data may not match.
11. DBMS provides an interface between:
Answer: Applications and data
Rationale: Applications don’t directly access data files.
, 12. Which is NOT a DBMS advantage?
A. Improved security
B. Reduced redundancy
C. Increased inconsistency
D. Data sharing
Answer: C
Rationale: DBMS reduces inconsistency.
13. Database systems replace which traditional approach?
Answer: File-based systems
Rationale: DBMS solves file system limitations.
14. A database is usually stored on:
Answer: Secondary storage
Rationale: Databases are large and persistent.
15. DBMS supports data independence. True or False?
Answer: True
Rationale: Applications are insulated from data structure changes.
SECTION B: FILE SYSTEM VS DBMS (16–30)
16. File-based systems suffer from:
Answer: Data redundancy
Rationale: Separate files lead to duplicated data.
17. Which problem is most severe in file systems?
A. Data security
B. Data inconsistency
C. Program-data dependence
D. All of the above
Answer: D
Rationale: File systems suffer from all these issues.
1 LATEST UPDATE 2026 QUESTIONS WITH
CORRECT ANSWERS PLUS RATIONALES |
GRADED A
1. What is a Database?
Answer: A structured collection of related data
Rationale: Databases store data in an organized way to allow efficient access and management.
2. A DBMS is best described as:
A. A programming language
B. A file system
C. Software for managing databases
D. A hardware device
Answer: C
Rationale: A DBMS is software that creates, manages, and controls access to databases.
3. Which of the following is NOT a function of a DBMS?
A. Data storage
B. Data security
C. Data redundancy increase
D. Data retrieval
Answer: C
Rationale: DBMSs aim to reduce, not increase, redundancy.
4. Example of a DBMS:
A. Microsoft Word
B. Oracle
C. Linux
D. Python
Answer: B
Rationale: Oracle is a relational DBMS.
,5. Which is NOT a database application?
A. Banking system
B. Airline reservation
C. Payroll system
D. Text editor
Answer: D
Rationale: Text editors don’t manage structured databases.
6. The main goal of a DBMS is to:
Answer: Provide efficient and secure data access
Rationale: Efficiency, security, and consistency are core DBMS goals.
7. Data in a database is usually:
Answer: Logically related
Rationale: Databases store related data, not random files.
8. DBMS allows multiple users to:
Answer: Access data concurrently
Rationale: Concurrency control is a key DBMS feature.
9. Which term refers to unnecessary duplication of data?
Answer: Data redundancy
Rationale: Redundancy leads to inconsistency and wasted storage.
10. Which problem occurs when redundant data is updated inconsistently?
Answer: Data inconsistency
Rationale: Different copies of the same data may not match.
11. DBMS provides an interface between:
Answer: Applications and data
Rationale: Applications don’t directly access data files.
, 12. Which is NOT a DBMS advantage?
A. Improved security
B. Reduced redundancy
C. Increased inconsistency
D. Data sharing
Answer: C
Rationale: DBMS reduces inconsistency.
13. Database systems replace which traditional approach?
Answer: File-based systems
Rationale: DBMS solves file system limitations.
14. A database is usually stored on:
Answer: Secondary storage
Rationale: Databases are large and persistent.
15. DBMS supports data independence. True or False?
Answer: True
Rationale: Applications are insulated from data structure changes.
SECTION B: FILE SYSTEM VS DBMS (16–30)
16. File-based systems suffer from:
Answer: Data redundancy
Rationale: Separate files lead to duplicated data.
17. Which problem is most severe in file systems?
A. Data security
B. Data inconsistency
C. Program-data dependence
D. All of the above
Answer: D
Rationale: File systems suffer from all these issues.
