Which action can be performed on partitions independently of the other partitions?
Which action can be performed on partitions independently of the other partitions?
What characterizes transaction durability?
What characterizes transaction durability?
When a SQL statement uses the BROWSE ACCESS clause, _______.
When a SQL statement uses the BROWSE ACCESS clause, _______.
Which component coordinates the transaction commit of network (distributed) transactions?
Which component coordinates the transaction commit of network (distributed) transactions?
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 method(s) can generally be used?
In order to have TMF use a tape other than the one requested for a DUMP operation, which
method(s) can generally be used?
Which utilities can be used to monitor SQL table space?
Which utilities can be used to monitor SQL table space? Select TWO.
Why is file recovery used?
Why is file recovery used? Select THREE.
Which MAXEXTENTS value maximizes the table size?
A Format 1 partition has primary and secondary extents of 5000 pages. Which MAXEXTENTS
value maximizes the table size?
What is the maximum number of physical I/Os needed to retrieve a base table row for a specific index value usi
Click on the Exhibit button to show the result of a FILEINFO, STAT, PARTONLY of a base table and index.
What is the maximum number of physical I/Os needed to retrieve a base table row for a specific
index value using these partitions?