nerdexam
Oracle

1Z0-338 · Question #83

You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O sayings as a result of the storage indexes. Which two statements are true? (Choose two.)

The correct answer is D. The storage index data is not on the Cell Server's region index memory structures yet because this. Explanation/Reference:

Monitoring and Managing Exadata

Question

You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O sayings as a result of the storage indexes. Which two statements are true? (Choose two.)

Exhibit

1Z0-338 question #83 exhibit

Options

  • AThe accumulated I/O saved by the storage index is 1.68 MB.
  • CSince the database was started, no queries were run against this table with the same predicate.
  • DThe storage index data is not on the Cell Server's region index memory structures yet because this
  • EThe storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.

How the community answered

(33 responses)
  • A
    3% (1)
  • C
    12% (4)
  • D
    82% (27)
  • E
    3% (1)

Explanation

Explanation/Reference:

Topics

#storage indexes#I/O savings#Cell Server#region index memory

Community Discussion

No community discussion yet for this question.

Full 1Z0-338 Practice