Oracle Transaction Control Statements: Beginner-Level Quiz

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

A ______ database state is one in which all data integrity constraints are satisfied.

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

Which of the following statements is not correct;

______ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

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

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

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.

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

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

The ______ statement is used to end a successful transaction.

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

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

A transaction in Oracle ensures that either all of the command succeeds or none of the commands succeeds. True or False?

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.

If we are inserting / updating / deleting data to/from a table then we are performing a transaction on a table. True or False?

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?

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

In a(n) ______ backup of the database, only the last modifications to the database are copied.

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