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?
The purpose of a smaller LOCKLENGTH value is to _______.
The purpose of a smaller LOCKLENGTH value is to _______.
Which database object stores user application data?
Which database object stores user application data?
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?
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 _______.
Which action can be performed on partitions independently of the other partitions?
Which action can be performed on partitions independently of the other partitions?
When a SQL statement uses the BROWSE ACCESS clause, _______.
When a SQL statement uses the BROWSE ACCESS clause, _______.
A single row SELECT statement is preferable to a cursor SELECT statement when only one row needs to be retriev
A single row SELECT statement is preferable to a cursor SELECT statement when only one row
needs to be retrieved because _______.
Which utilities can be used to monitor SQL table space?
Which utilities can be used to monitor SQL table space? Select TWO.