Oracle Transaction Control Statements: Beginner-Level Quiz

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

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

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

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

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

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

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

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

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

Which of the following statements is not correct;

What is the use of the ROLLBACK command in oracle?

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

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.

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

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

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

The ______ statement is used to end a successful transaction.

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

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

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.