To generate database object statistics manually,you could use the following syntax: ____. 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,you could use the following syntax: ____. 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 for generating database object statistics manually is "ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;". The COMPUTE STATISTICS keyword is used to instruct the database to compute and store the statistics for the specified table or index. Option A is incomplete, as it is missing the COMPUTE STATISTICS keyword. Option B is used for creating a new table or index, not generating statistics for an existing one. Option D is also incorrect because CREATE statements do not generate statistics.

To Generate Database Object Statistics Manually,you Could Use the Following