Multiple Choice
To generate database object statistics manually,you could use the following syntax: ____.
A) ANALYZE <TABLE/INDEX> object_name;
B) CREATE <TABLE/INDEX> object_name;
C) ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;
D) CREATE <TABLE/INDEX> object_name COMPUTE STATISTICS;
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q22: are special instructions for the optimizer that
Q24: If there is no index, the DBMS
Q30: The data cache or _ is a
Q51: _ is a measure of how likely
Q53: When setting optimizer hints,_ forces the optimizer
Q56: A(n)_ request is a low-level (read or
Q58: A(n)_ is a logical grouping of several
Q60: On the server side,the DBMS environment must
Q62: A conditional expression is normally expressed within
Q69: Why do we need to optimize a