Multiple Choice
To generate database object statistics manually, following syntax should be used in Oracle:
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
Q5: A(n) _ is good for simple and
Q6: How should storage volumes be allocated for
Q7: A DBA determines the initial size of
Q8: The LIKE conditional operator is used by
Q9: The _ cache is used as a
Q11: _ are ordered sets of values that
Q12: RAID systems use a single disk to
Q13: The purpose of an I/O operation is
Q14: On the client side, the objective is
Q15: A(n) _ tablestores the end-user data and