Oracle SQL Oracle SQL Transactions and Concurrency Control

Question 1

What SQL command permanently saves all changes made in the current Oracle transaction to the database?

Accepted Answer

COMMIT

Answer

COMMIT permanently saves all pending DML changes made in the current transaction to the database.

Question 2

Which Oracle SQL statement undoes all uncommitted changes made in the current transaction?

Accepted Answer

ROLLBACK

Answer

ROLLBACK undoes all uncommitted DML changes in the current transaction, restoring data to the last committed state.

Question 3

What is the purpose of the SAVEPOINT statement in Oracle SQL?

Accepted Answer

To create a named checkpoint within a transaction that can be rolled back to

Answer

SAVEPOINT creates a named point within a transaction, allowing partial rollback to that specific point rather than rolling back the entire transaction.

Question 4

Which Oracle SQL syntax correctly rolls back a transaction to a savepoint named 'SP1'?

Accepted Answer

ROLLBACK TO SAVEPOINT SP1

Answer

The correct syntax is ROLLBACK TO SAVEPOINT savepoint_name to undo changes back to the specified savepoint.

Question 5

Which event causes an implicit (automatic) COMMIT in Oracle SQL?

Accepted Answer

Executing a DDL statement such as CREATE TABLE

Answer

DDL statements (CREATE, ALTER, DROP, TRUNCATE) in Oracle implicitly issue a COMMIT before and after executing, finalizing any pending transactions.

Oracle SQL Practice Test

Oracle SQL Practice Test

Oracle SQL Oracle SQL Transactions and Concurrency Control