PLSQL Set 4

All changes are undone made by all of the SQL statements ✘ The transaction locks of data is released ✘ The transaction ends ✘ All of these ✔

It is a statement that can be executed without errors. ✘ It is a statement that generates calls to an instance, including only the DDL statements. ✘ It is a statement that generates calls to an instance including only the DML statements. ✘ It is a statement that generates calls to an instance, including the DML and the DDL statements. ✔

Savepoint ✘ Rollback ✘ Commit ✘ Comment ✔

Statement-level rollback ✘ Row-level rollback ✘ Deadlock ✘ None of these ✔

SET TRANSACTION ... NAME ✘ TRANSACTION ... NAME ✘ TRANSACTION ... NAME = ✘ SET TRANSACTION = NAME ✔

A COMMIT or a ROLLBACK statement is issued ✘ User disconnects from Oracle ✘ User processes & terminates abnormally ✘ All of these ✔

Rule based ✘ Cost based ✘ Both of these ✘ None of these ✔

Redo log entries are written in the SGA's redo log buffers to the online redo log file. ✘ Transaction's SCN is written to the online redo log file. ✘ Both of these ✘ None of these ✔

An in-doubt distributed ✘ A doubt distributed ✘ An in-doubt ✘ None of these ✔

Creating a job ✘ Altering a job ✘ Running a job ✘ Disabling a job ✔