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

SAVE

Answer

PERSIST

Answer

FLUSH

Question 2

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

Accepted Answer

ROLLBACK

Answer

UNDO

Answer

REVERT

Answer

CANCEL

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

To permanently save a transaction to disk

Answer

To save the current database schema state

Answer

To create a backup of the transaction log

Question 4

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

Accepted Answer

ROLLBACK TO SAVEPOINT SP1

Answer

ROLLBACK SP1

Answer

ROLLBACK TO SP1

Answer

REVERT TO SAVEPOINT SP1

Question 5

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

Accepted Answer

Executing a DDL statement such as CREATE TABLE

Answer

Executing a SELECT statement with ORDER BY

Answer

Opening a new SQL*Plus session

Answer

Executing a MERGE statement

Question 6

What happens to all row-level locks held by a transaction when COMMIT is issued in Oracle?

Accepted Answer

All locks are immediately released

Answer

Locks are converted to shared locks

Answer

Locks remain until the next DML operation

Answer

Locks are transferred to the next waiting transaction

Question 7

In Oracle, which of the following best describes a transaction?

Accepted Answer

A logical unit of work consisting of one or more SQL statements that must all succeed or all fail

Answer

A single SQL SELECT statement that reads data

Answer

A collection of stored procedures grouped by schema

Answer

A scheduled batch job registered in the database scheduler