DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Multiuser access control
|
|
|
Sophisticated algorithms ensure that multiple users can access the database concurrently without compromising its integrity
|
|
|
Enables recovery of the database after a failure
|
|
|
Minimizes redundancy and maximizes consistency
|
Detailed explanation-1: -Recovery techniques in DBMS are used to recover the data when the new state of the data is lost or the entire data in the system is lost. Logs are used to keep a record of the actions in a database and these logs are used to recover the data to the database.
Detailed explanation-2: -In general, the purpose of a backup and recovery strategy is to protect the database against data loss and reconstruct the database after data loss. Typically, backup administration tasks include the following: Planning and testing responses to different kinds of failures.
Detailed explanation-3: -Backup copies allow data to be restored from an earlier point in time to help the business recover from an unplanned event. Storing the copy of the data on separate medium is critical to protect against primary data loss or corruption.
Detailed explanation-4: -Backup and recovery is the process of duplicating data and storing it in a secure place in case of loss or damage, and then restoring that data to a location-the original one or a safe alternative-so it can be again used in operations.