Oracle Transaction Control Statements: Beginner-Level Quiz

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

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

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

What is the use of the ROLLBACK command in oracle?

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

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?

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

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

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

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.

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

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

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

The ______ statement is used to end a successful transaction.

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?

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

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

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

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