1Z0-338 Question #33: Real Exam Question with Answer & Explanation

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_STATE'S region index is populated with high and low values for the OBJECT_ID column during the l/O request.