Oracle Transaction Control Statements: Beginner-Level Quiz

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.

A transaction can include multiple SQL statements. True or False?

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

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

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

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

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

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

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

Which statement allows you to create a marker to which you can later roll back?

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

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

If a transaction is not explicitly committed or rolled back, the changes are saved automatically by Oracle. True or False?

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

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

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.

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

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?

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