Oracle 1z1-485 Actual Free Exam Questions & Community Discussion

What are two impacts of selecting high redundancy over normal redundancy for your diskgroups?

When using IORM, which statement accurately describes when redo log file writes take place?

You are asked to enable Write Back Flash Cache for one of your customers X3-2 Full Rack in a rolling fashion. Put the following steps in the right order:
A) Set flashCacheMode to writeback.
B) Inactivate all grid disks and shut down cellsrv.
C) Drop the Flash Cache.
D) Verify that cell for flashcacheMode is writeback.
E) Create the Flash Cache.
F) Start up cellsrv and activate all grid disks.
G) Check grdidksk asmdeactivationoutcome and asmmodestatus for all grid disks to ensure that all grid disks on all cells are set to Yes and online, respectively.

Which two actions are permitted with Exadata Database Machine?

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

Which two statements describe correct network configuration for Exadata Database Machine?

What are the three customer options for hosting the Platinum Services Advanced Support Gateway?

Storage indexes are unique to the 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 I MO storage regions.
2.cellsrv checks the high and low values, and determines the storage region does not contain any values meeting 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.MYOBJ_STATE'S region index is populated with high and low values for the OBJECT_ID column during the I/O request.