Which of the following is the preferred way to recover a database afte – McqOptions

MCQOPTIONS

1.	Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
A.	Rollback
B.	Rollforward
C.	Switch to duplicate database
D.	Reprocess transactions
Answer» B. Rollforward

Discussion

No Comment Found

Related MCQs

Incorrect data is easy to detect.
Queries that do full table scans should be avoided.
Data modeling and database design are key responsibilities of data and data base administration.
Mirrored databases are almost always provided in high-availability systems.
The restore/rerun technique involves reprocessing the day's transactions up to the point of failure.
With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.
Databases are not the property of a single function or individual within the organization.
A disaster recovery plan does not need to include the shipment of database backups to other sites.
Concurrency control is important for which of the following reasons?
Information repositories are replacing data dictionaries in many organizations.