To generate database object statistics manually, following syntax should be used in Oracle: A) ANALYZE object_name; B) CREATE
object_name; C) ANALYZE
object_name COMPUTE STATISTICS; D) CREATE
object_name COMPUTE STATISTICS;

Question

To generate database object statistics manually, following syntax should be used in Oracle: A) ANALYZE object_name; B) CREATE

object_name; C) ANALYZE

object_name COMPUTE STATISTICS; D) CREATE

object_name COMPUTE STATISTICS;

Quizplus · Accepted Answer

The correct syntax to generate database object statistics manually is ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS. The COMPUTE STATISTICS keyword is necessary to ensure that statistics are computed for the object. Therefore, option C is the correct choice. Option A and B are incorrect because they do not include the COMPUTE STATISTICS keyword. Option D is also incorrect because CREATE is used to create a new object, not to generate statistics for an existing object.

To Generate Database Object Statistics Manually, Following Syntax Should Be