QUESTION: 29

Given:
USING (x INTEGER, y INTEGER, z INTEGER) EXEC Macro1(:x, :y, :z);
Which three statements about the execution of this macro are true? (Choose three.)

It will be cached immediately.
It contains multiple statements.
No values are present for the Optimizer.
It should be demographically dependent.
It should be demographically independent.

Answer(s): A,C,E

Reveal Solution Next Question

QUESTION: 30

Which three are valid considerations for optimal system performance? (Choose three.)

Statistics are collected on all indexes.
Primary indexes are chosen based on access, uniqueness, and stable data values.
The disk space consumed by a secondary index negatively impacts OLTP applications.
The performance benefit of a secondary index for OLTP applications outweighs the performance cost for batch maintenance.

Answer(s): A,B,D

Reveal Solution Next Question