Oracle Oracle Certifications 1Z0-485 Questions & Answers

• Question 41:

  How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?

  A. Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.

  B. Using partition pruning can force the optimizer to use that method instead of Smart Scan. Partitioning in Exadata should be used wisely,

  C. Partition pruning is not a supported option in the 11gR2 database code that runs on an Exadata Machine, due to issues with Cost Based Optimizer plans.

  D. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.

  E. Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.

  Correct Answer: A

• Question 42:

  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 (穋ell physical IO bytes eligible for predicate offload', 穋ell physical IO interconnect bytes', 穋ell physical IO bytes saved by storage index',

  100% Real QandAs | 100% Real Pass

  穋ell 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

  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.

  Correct Answer: BC

• Question 43:

  You are concerned about how to recover from a failed Exadata Storage Server. What is the best way to recover from a storage cell failure when content in both system disks is lost?

  A. Database Machine Administrators should be prepared by creating a backup using dbserver_backup.sh.

  B. Database Machine Administrators should be prepared by creating a backup to an NFS file location as described in the owners guide.

  C. Any USB can be plugged in to create a backup.

  D. Be sure that you have a backup by running make_cellboot_usb.sh in /opt/oracle.cellos.

  E. Use the Exadata Storage Server rescue functionality that Is provided on the CELLBOOT USB flash drive.

  F. Re-imaging the cell is the only option.

  Correct Answer: E

• Question 44:

  When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?

  A. Replace the disk and run MegaCLI to rebuild the degenerate mirror.

  B. No manual action is required because Automatic Storage Management (ASM) fast mirror resync is automatic

  C. No manual action is required because ASM rebalancing is automatic.

  D. Replace the disk and manually copy the mirror extents to the new drive.

  E. Run RMAN REPAIR FAILURE.

  Correct Answer: C

• Question 45:

  When should you use Hybrid Columnar Compression?

  A. always

  B. on large active tables where deeper compression is desired

  C. on tables or partitions that have fairly static data

  D. on every table where Advanced Compression is not used

  Correct Answer: C

• Question 46:

  High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?

  A. Enable Write-Back Flash Cache due to heavy DBWR usage.

  B. Enable Write-Back Flash Cache due to heavy LGWR usage.

  C. Swap hard disks to High Capacity disks.

  D. Tune the application to reduce I/O requests. 100% Real QandAs | 100% Real Pass

  E. Leverage IORM to give priority to critical workloads.

  Correct Answer: BDE

• Question 47:

  Identify the three values to which the CELL_FLASH_CACHE attribute can be set.

  A. READ

  B. WRITE

  C. KEEP

  D. DEFAULT

  E. NONE

  Correct Answer: CDE

• Question 48:

  In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?

  A. Enable Smart Flash Log.

  B. Execute alter table ... cell_flash_cache=keep on heavily scanned tables.

  C. Enable Write Back Flash Cache.

  D. Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.

  Correct Answer: B

• Question 49:

  Which Exadata feature eliminates unnecessary data transfers between database nodes and storage?

  A. database views

  B. InfiniBand networking

  C. Flash Cache

  D. high performance SAS2 disk drives

  E. cell offloading

  Correct Answer: C

• Question 50:

  Your customer is hesitant to install the Oracle Configuration Manager in their environment. Give them three ways in which it will benefit their Exsdata Database Machine support experience and potentially resolve some of the issues they are having with the length of time it is taking Oracle to process their Exadata Service Requests (SRs).

  A. Host information can be gathered and sent to Oracle for license compliance.

  B. Potential issues can be addressed before they impact operations.

  C. Priority handling can be extended for SRs, with attached configuration.

  D. Exadata patching cannot be done successfully without the Oracle Configuration Manager.

  E. Root cause analysis can be accelerated.

  Correct Answer: BCE