Oracle Exam 1z0-338 Topic 8 Question 47 Discussion

Actual exam question for Oracle's 1z0-338 exam

Question #: 47
Topic #: 8

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.)

AThe accumulated I/O saved by the storage index is 1.68 MB

BThe storage indexes reduced the amount of physical I/O bytes significantly for this query.

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 predicate has not been used.

EThe storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.

Show Suggested Answer

Suggested Answer: B, D

by Lettie at May 03, 2022, 07:16 AM

Limited Time Offer

25%

Off

Get Premium 1z0-338 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!