Oracle Service Cloud Developer — Question 32

Storage indexes are unique to Exadata Database Machine and their primary goal is to reduce the amount of I/O required to service I/O requests for Exadata Smart
Scan. Put the following steps in order:
1. The Exadata cell services software conducts I/O requests on 1 MB storage regions.
2. cellsrv checks the high and low values, and determines that the storage region does not contain any values that meet the predicate.
3. The database is started.
4. Physical I/O to the region is bypassed if the query selection falls outside the high/low storage index storage.
5. A query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=1500.
6. A subsequent query is issued against the MYOBJ_CTRL table that has a predicate OBJECT_ID=2234.
7. The MYOBJ_STATES region index is populated with high and low values for the OBJECT_ID column during the l/O request.

Answer options

• A. 3, 5, 1, 7, 6, 2 and 4
• B. 3, 7, 1, 5, 6, 2, and 4
• C. 3, 7, 5, 2, 1, 6, and 4
• D. 3. 6, 1, 7, 2, 5, and 4
• E. 3, 5, 2, 1, 6, 7, and 4

Correct answer: E

Explanation

The correct sequence starts with the database being initiated, followed by issuing a query, then checking the storage index and populating it, and finally bypassing physical I/O if necessary. Options A, B, C, and D do not correctly reflect the logical order of operations as they misplace crucial steps in the process.