Statistics can be gathered manually using a command-line tool such as SQL*Plus,with the ____ command or the DBMS_STATS package.
A) OPTIMIZE
B) ANALYZE
C) STATSPACK
D) TRCSESS

Question

Quizplus · Accepted Answer

The ANALYZE command can be used to gather statistics manually in SQL*Plus or any other command-line tool. The OPTIMIZE command, STATSPACK, and TRCSESS are not used for gathering statistics.

Statistics Can Be Gathered Manually Using a Command-Line Tool Such