which normal form?
Foreign keys are used in the normalization process as consequences of which normal form?
Which statement can avoid a table scan?
A large table $D.A.T (EmployeeNo(primaryKey), Name, LastName, Salary, Dept, Address) has an
index (Name, LastName). Which statement can avoid a table scan?
Which TMF feature supports the transaction durability property?
Which TMF feature supports the transaction durability property?
Which directive allows SQL to skip unavailable partitions?
Which directive allows SQL to skip unavailable partitions?
A foreign cursor is ______.
A foreign cursor is ______.
Which option of update statistics on a multi-partition table calculates the statistics in parallel on each par
Which option of update statistics on a multi-partition table calculates the statistics in parallel on
each partition and gives the most accurate results?
Which SQL component detects a condition requiring recompilation?
Which SQL component detects a condition requiring recompilation?
Which users are allowed to create user catalogs on \\LOCAL?
The system catalog subvolume is secured with the following security: \\LOCAL.$DSMSCM.SQL.*
owner = 1,255; security = “oooo” \\LOCAL.$DSMSCM.SQL.CATALOGS owner = 1,255; security =
“ngoo”
Which users are allowed to create user catalogs on \\LOCAL?
Which utility can be used to make more space available within the table without turning audit off?
An audited key-sequenced table is approaching capacity in terms of the maximum number of
extents. Which utility can be used to make more space available within the table without turning
audit off?
The MEASURE SQLSTMT RECOMPILES counter with non-zero value indicates _______.
The MEASURE SQLSTMT RECOMPILES counter with non-zero value indicates _______.