Transaction atomicity implies that _______.
Transaction atomicity implies that _______.
How many locks can a given transaction hold against the SQL table?
$DATA.A.B is an audited SQL table. The disk process $DATA is using default configuration
values. How many locks can a given transaction hold against the SQL table?
What actions must be performed to change the audit trail file size?
TMF has been started. What actions must be performed to change the audit trail file size?
When should you perform UPDATE STATISTICS on a table?
When should you perform UPDATE STATISTICS on a table?
Which configuration accommodates the different requirements of A and B, while minimizing tape utilization?
A system hosts two TMF-enabled applications. Application A requires full TMF protection (online and
audit dumping). Application B does not. Application A uses data volumes $A01-$A10, while B uses
$B01-$B10. Which configuration accommodates the different requirements of A and B, while
minimizing tape utilization?
What causes the SQLCOMP to fail if this program is restored using the SQLCOMP ON option of the restore program
A customer has a backup of an SQL program that has NOT previously been SQL compiled. What
causes the SQLCOMP to fail if this program is restored using the SQLCOMP ON option of the
restore program?
Which SQLCI command sequence provides statistics about a query?
Which SQLCI command sequence provides statistics about a query?
What is the relationship of TMF audit trails to data files?
What is the relationship of TMF audit trails to data files?
Which volume is prohibited for SQL table location?
Which volume is prohibited for SQL table location?
When restarting a homogeneous TMF environment which includes distributed transactions, TMF will not enable beg
When restarting a homogeneous TMF environment which includes distributed transactions, TMF will
not enable begintransactions until _______.