Which utility should be used to obtain the access paths details?

  1. QUIESCE

  2. EXPLAIN

  3. REORG

  4. RUNSTATS


Correct Option: B
Explanation:

To answer this question, the user needs to have a basic understanding of database management systems and utilities used to manage databases.

QUIESCE is a utility used to temporarily halt the activity on the database, allowing for maintenance operations to take place. It is not used to obtain access path details.

EXPLAIN is a utility used to display the access path details for a particular SQL statement. This option is correct.

REORG is a utility used to reorganize the physical storage of a database table, and is not used to obtain access path details.

RUNSTATS is a utility used to collect statistical information about the data contained in a database table, and is not used to obtain access path details.

Therefore, the correct answer is:

The Answer is: B. EXPLAIN

Find more quizzes: