DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Backup and recovery management
|
|
|
Sophisticated algorithms ensure that multiple users can access the database concurrently without compromising its integrity
|
|
|
Minimizes redundancy and maximizes consistency
|
|
|
Enables recovery of the database after a failure
|
Detailed explanation-1: -Multi User Access Control Multiuser access control is another important DBMS Function. To provide data integrity and data consistency, the DBMS uses sophisticated algorithms to ensure that multiple users can access the database concurrently without compromising the integrity of the database.
Detailed explanation-2: -11) Enterprise Database Such a database allows simultaneous access to users.
Detailed explanation-3: -Multiuser and Concurrent Access − DBMS supports multi-user environment and allows them to access and manipulate data in parallel. Though there are restrictions on transactions when users attempt to handle the same data item, but users are always unaware of them.
Detailed explanation-4: -A database management system must include concurrency control subsystems. This feature ensures that data remains consistent and valid during transaction processing even if several users update the same information.