Free 1Z0-485 Web TestEngine Demo

Q1 Multiple choice

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

SQL> select count (*) from transmap.mymap_comp
2 where map_id between 400 and 500;
COUNT(*)
---------------------------------------103000
Elapsed: 00:00:00.08

SQL> select b.name, a.value/1024/1024 value
from vSmystat a, vSstatname b,
where b.statistic# = a.statistic#
and b.nafne in (-cell physical IO bytes eligible for predicate offload', -cell physical IO interconnect bytes', -cell physical IO bytes saved by storage index',

100% Real Q&As | 100% Real Pass

-cell physical IO interconnect bytes returned by smart scan') order by 1;

Statistic Value (MB)
--------------------------------------------------------------------------------------------- ----------------- cell physical IO bytes
eligible for predicate offload 2,255 .09 cell physical IO bytes saved by storage index .00
cell physical IO interconnect bytes 1.72
cell physical IO interconnect bytes returned by smart scan 1.68

Select all that apply.

A
The storage indexes were disabled using the DISABLE_STORAGE_INDEX Parameter.
B
Storage Index data is not on the Cell Server's region index memory structures yet because this
predicate has not been used.
C
Since the database was started, no quires were run against this table with the same predicate.
D
The storage indexes reduced the amount of physical I/O bytes significantly for this query.

1Z0-485 Web TestEngine demo