Oracle Transaction Control Statements: Beginner-Level Quiz

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

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

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?

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 a transaction is not explicitly committed or rolled back, the changes are saved automatically by Oracle. 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.

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

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

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

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.

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

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

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

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

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

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

Which of the following statements is not correct;