| Exam Code/Number: | 1z0-485Join the discussion |
| Exam Name: | Oracle Exadata Database Machine 2014 Implementation Essentials |
| Certification: | Oracle |
| Question Number: | 71 |
| Publish Date: | Jun 03, 2026 |
|
Rating
100%
|
|
Which two actions are permitted with Exadata Database Machine?
When would be the best time to run an Exadata health check (exachk)?
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',
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
When should you use Hybrid Columnar Compression?
You are concerned about how recovery from a failed Exadata Storage Server would work. Which statement is true about the Exadata CELLBOOT USB?