What most accurately describes the difference between the SQL statement COMMIT WORK and the Guardian procedure
What most accurately describes the difference between the SQL statement COMMIT WORK and
the Guardian procedure ENDTRANSACTION?
which processors do the TMFMON and associated surrogate TMFMON2 processes run?
In which processors do the TMFMON and associated surrogate TMFMON2 processes run?
What happens?
$data.tab.employee is a large partitioned table with no indexes. Parallel execution is enabled for
the statement “select min (salary) from $data.tab.employee”. What happens?
How does the FREE RESOURCES statement change the locks on the table?
An SQL application has an updatable cursor open against an audited table which uses
REPEATABLE access. The application updates every third row that it reads and it has updated
three rows. How does the FREE RESOURCES statement change the locks on the table?
Which database object stores user application data?
Which database object stores user application data?
The purpose of a smaller LOCKLENGTH value is to _______.
The purpose of a smaller LOCKLENGTH value is to _______.
The TOPHYSVOL parameter of the TMFCOM recover files command is used to _______.
The TOPHYSVOL parameter of the TMFCOM recover files command is used to _______.
how can the file label and catalog entries be compared?
If an audited SQL table has been dropped in error, it may be recovered using TMF RECOVER
FILES as long as an online dump has been taken previously. Once the SQL table and its
associated objects have been recovered, how can the file label and catalog entries be compared?
Which action does TMF perform during TMF overflow processing?
Which action does TMF perform during TMF overflow processing?
The declaration of a cursor must include the "FOR UPDATE OF" clause when _______.
The declaration of a cursor must include the “FOR UPDATE OF” clause when _______.