📘 Advantages of Database Approach – MCQs (1–30)
Q1. Which of the following is a major advantage of the database approach over the file-based
system?
A) Complexity
B) Redundancy
C) Data Independence
D) Increased Data Duplication
Answer: C
Explanation: DBMS allows logical and physical data independence.
Q2. In DBMS, reduced data redundancy means:
A) Storing the same data in many places
B) Minimizing duplicate data
C) Using large storage
D) Storing data only in the cloud
Answer: B
Explanation: Redundancy is reduced using normalization and central data control.
Q3. What ensures correctness and consistency in stored data?
A) Data security
B) Data integrity
C) Data redundancy
D) Data dictionary
Answer: B
Explanation: Integrity rules (e.g., constraints) ensure data correctness.
Q4. Centralized control of data is mainly useful for:
A) Performance improvement
B) Data redundancy
C) Data security and consistency
D) Manual processing
Answer: C
Explanation: Central control allows better access control and uniform data management.
Q5. What improves if data is managed using a DBMS instead of flat files?
A) Disk rotation
B) Software cost
C) Query optimization and access
D) Printer speed
Answer: C
Explanation: DBMS uses indexing and optimization techniques.
Q6. Data consistency is achieved in DBMS by:
A) Manual updates
B) Replication
C) Data centralization
D) User control
Answer: C
Explanation: Centralized data ensures all users see the same values.
Q7. A data dictionary is used in DBMS to:
A) Store actual data
B) Encrypt tables
C) Maintain metadata
D) Print reports
Answer: C
Explanation: It stores information about tables, columns, constraints, etc.
Q8. Which of the following is not an advantage of the DBMS approach?
A) Improved data sharing
B) Increased redundancy
C) Enhanced data integrity
D) Centralized data control
Answer: B
Explanation: DBMS reduces redundancy, not increases it.
Q9. DBMS allows data abstraction, which helps in:
A) Hiding storage details from users
B) Improving hardware
C) Direct file access
D) Printing large files
Answer: A
Explanation: Abstraction hides the internal structure from the user.
Q10. What is one benefit of concurrent access in a DBMS?
A) More memory required
B) Multiple users can safely access data
C) Increased redundancy
D) Manual backup only
Answer: B
Explanation: Concurrency control manages multi-user access properly.
Q11. Which property helps ensure data reliability even during a system crash?
A) Indexing
B) Concurrency
C) Recovery mechanism
D) Views
Answer: C
Explanation: DBMS provides recovery tools to restore lost data.
Q12. Data independence refers to:
A) Being able to work without Internet
B) Application unaffected by data changes
C) Data stored without formats
D) Users modifying memory
Answer: B
Explanation: Logical/physical structure changes don’t affect applications.
Q13. In DBMS, query optimization leads to:
A) Poor performance
B) Random answers
C) Faster data access
D) Duplicate records
Answer: C
Explanation: Query optimizer improves execution plan and speed.
Q14. What provides a customized view of data in DBMS?
A) Index
B) Key
C) View
D) Table
Answer: C
Explanation: Views give limited access as per user requirements.
Q15. DBMS helps enforce standards for data using:
A) Random fields
B) Stored procedures
C) Constraints and data types
D) Joins only
Answer: C
Explanation: Standards are enforced through schema definitions.
Q16. What ensures unauthorized access is restricted in DBMS?
A) Authentication and access control
B) Query tools
C) Data warehouse
D) Joins
Answer: A
Explanation: DBMS has user roles, permissions, and login security.
Q17. Which is a benefit of using DBMS in large organizations?
A) Increased inconsistency
B) Data independence and sharing
C) Manual data sorting
D) Lack of recovery
Answer: B
Explanation: DBMS improves data handling in complex environments.
Q18. Recovery of data after a crash is possible in DBMS using:
A) Data warehouse
B) Index files
C) Transaction logs and backups
D) Joins
Answer: C
Explanation: Logs track changes; backups restore old states.
Q19. Data isolation in file systems is a problem. How is this addressed in DBMS?
A) Using data encryption
B) Keeping data unshared
C) Using schema and integration
D) Deleting data often
Answer: C
Explanation: DBMS integrates all data, reducing isolation issues.
Q20. A key advantage of DBMS in multi-user environments is:
A) Increased manual effort
B) Lack of synchronization
C) Controlled simultaneous access
D) Fixed reports
Answer: C
Explanation: DBMS manages concurrency with locks and protocols.
Q21. The advantage of data integrity means:
A) Redundant data
B) Accurate and valid data
C) Hardware duplication
D) Open source tools
Answer: B
Explanation: Data is checked using rules, constraints, and keys.
Q22. Reduced program-data dependency means:
A) Programs are tied to data
B) Programs are independent of how data is stored
C) Data changes often
D) Programs need rewriting
Answer: B
Explanation: Applications don’t break when internal data storage changes.
Q23. Which of these is maintained automatically by DBMS?
A) Data inconsistency
B) Index corruption
C) Referential integrity
D) Manual locks
Answer: C
Explanation: Foreign keys ensure relational consistency.
Q24. What is the impact of centralized data in DBMS?
A) Fragmentation
B) Security challenges
C) Better control and coordination
D) Manual access
Answer: C
Explanation: Centralized system gives unified control over data access.
Q25. DBMS supports backup and recovery, ensuring:
A) Data is never lost
B) Changes are always erased
C) Restoring database to previous consistent state
D) Manual copying
Answer: C
Explanation: DBMS maintains data durability using logs and backups.
Q26. Which layer of abstraction provides user-specific views?
A) Physical
B) Logical
C) External
D) Relational
Answer: C
Explanation: External schema customizes user-level data access.
Q27. DBMS improves productivity of developers by:
A) Increasing code length
B) Providing data manipulation languages
C) Hiding data
D) Disabling queries
Answer: B
Explanation: SQL and other languages ease development.
Q28. What helps reduce data inconsistency in DBMS?
A) Multiple copies
B) Lack of keys
C) Central data access and integrity rules
D) File duplication
Answer: C
Explanation: A single source of data avoids mismatch.
Q29. One of the major cost-related advantages of DBMS is:
A) High software cost
B) Low development time
C) Less training
D) High maintenance
Answer: B
Explanation: Reusable components and data independence reduce cost/time.
Q30. Which of the following is a key benefit of DBMS?
A) Complex syntax
B) Data dependency
C) Easy access and manipulation
D) No abstraction
Answer: C
Explanation: SQL and tools provide easy data handling.
