Oracle Transaction Control Statements: Beginner-Level Quiz

The ______ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.

When the recovery procedure uses _____, the database is immediately updated by transaction operations during the transaction's execution, even before the transaction reaches its commit point.

The Oracle RDBMS uses the ______ statement to declare a new transaction start and its properties.

What is the use of the ROLLBACK command in oracle?

If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the _____ property is violated and the database is no longer consistent.

When a program is abnormally terminated, the equivalent of a ______ command occurs.

Although the ______ locking approach improves the availability of data, its management requires high overhead.

______ ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure.

The process of trimming sets of inter-related Operations into a single unit and executing those operations by applying the do everything or do-nothing principle is called transaction management in Oracle. True or False?

A DBMS uses a transaction ______ to keep track of all transactions that update the database

In a ______ lock, the DBMS will lock an entire disk page.

A(n) ______ lock exists when concurrent transactions are granted Read access on the basis of a common lock.

What is the default behavior of Oracle in the absence of a COMMIT or ROLLBACK?

All transactions are controlled and executed by the DBMS (subject to some limitations) to guarantee database _____.

Once we execute the commit statement, we cannot revert back the changes. True or False?

All lock information is managed by a ______, which is responsible for assigning and policing the locks used by the transactions.

Deadlocks are possible only when one of the transactions wants to obtain a(n) ______ lock on a data item.

The rule of transaction tells that either all the statements in the transaction should be executed (all are committed) successfully or none of those statements to be executed (i.e. all are canceled or rollbacked). Is this statement true?

The three basic techniques to control deadlocks are: deadlock ______, deadlock detection, and deadlock avoidance.

According to the ANSI SQL standard, when does a transaction begin?