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.)
A.
The accumulated I/O saved by the storage index is 1.68 MB.
B.
The storage indexes reduced the amount of physical I/O bytes significantly for this query.
C.
Since the database was started, no queries were run against this table with the same predicate.
D.
The storage index data is not on the Cell Server’s region index memory structures yet because this
predicate has not been used.
E.
The storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.
B and E ?
yes.B and E.
Actually its CD
Explanation:
* cell physical I/O bytes eligible for predicate offload
Number of bytes eligible for predicate offload, an indication of smart scan
* (not D) cell physical I/O bytes saved by storage index
Here 0.
Number of bytes saved by a storage index; this is a reflection of how
many physical disk I/O bytes (and by proxy, requests) were saved
due to a storage index eliminating candidate blocks
CD
oracle exam expected B and E but I am not feel right about it.
C,D