PrepAway - Latest Free Exam Questions & Answers

What does Josh need to make sure is configured so that this type of activity does not continue?

Josh has figured out that software glitches and power fluctuations that caused systems to go off line has resulted in incorrect data being saved into the company database. What does Josh need to make sure is configured so that this type of activity does not continue?

PrepAway - Latest Free Exam Questions & Answers

A.
Commit functionality

B.
Rollback functionality

C.
Phased approach

D.
Referential approach

Explanation:
The rollback is an operation that ends a current transaction andcancels the current changes to the database. These changes could have taken place with the data itself or with schema changes that were typed in. When a rollback operation is executed, the changes are cancelled, and the database returns to its previous state. A rollback can take place if the database has some type of unexpected glitch or if outside entities disrupt its processing sequence. Instead of transmitting and posting partial or corrupt information, the database will roll back to its original state and log these errors and actions so they can be reviewed later.


Leave a Reply