Multiple choice technology databases

Which of the following events results in Automatic rollback?

  1. Exiting from SQL*Plus

  2. System crashing

  3. Issue of GRANT or CREATE command

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A system crash halts database operations abruptly without an orderly commit or rollback. Upon restart, the database performs crash recovery, which automatically rolls back any uncommitted transactions.

AI explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Exiting from SQL*Plus - This option is incorrect because exiting from SQL*Plus does not result in an automatic rollback. Exiting SQL*Plus simply ends the session without performing any additional actions.

Option B) System crashing - This option is incorrect because a system crash does not necessarily result in an automatic rollback. A system crash can cause data inconsistencies and potential data loss, but whether or not a rollback occurs depends on the recovery mechanisms in place.

Option C) Issue of GRANT or CREATE command - This option is incorrect because issuing a GRANT or CREATE command does not automatically trigger a rollback. These commands modify the database schema or access permissions but do not inherently trigger a rollback.

Option D) None of the above - This option is correct because none of the listed events (exiting from SQL*Plus, system crashing, issuing GRANT or CREATE command) result in an automatic rollback. Automatic rollback typically occurs in the event of a transaction failure or when explicit rollback commands are issued.

The correct answer is D) None of the above.

Keep practicing — related questions