Are you studying for the CEH or CISSP certifications?
Skillset can help you prepare! Sign up for your free Skillset account and take the first steps towards your certification.
Skillset can help you prepare! Sign up for your free Skillset account and take the first steps towards your certification.
There are multiple database controls which can be configured for integrity. Which of the following would occur or be executed if a user attempted to commit which could not be completed correctly?
Save point
Rollback
Commit
Checkpoint
The correct answer is rollback. A rollback would be executed to ensure integrity if a user attempted a commit which could not be completed correctly. A commit terminates a transaction and execute all changes made by a user. A save point is the known point before a failure or error occurred. A checkpoint saves the data in a memory segment to a temporary file.
Train with Skillset and pass your certification exam. Faster. Guaranteed.
Study thousands of practice questions that organized by skills and ranked by difficulty.
Create a tailored training plan based on the knowledge you already possess.
Know when you’re ready for the high-stakes exam. Have the confidence that you will pass on your first attempt.