Oracle Oracle Certifications 1z0-338 Questions & Answers

• Question 61:

  What are three ways to be informed of an Exadata Storage Sever disk failure? (Choose three.)

  A. review of the database server iostat output

  B. alert notifications through email when SMTP notification is configured

  C. review of the ILOM log

  D. review of the output of LIST ALERTHISTORY

  E. review of the output of SELECT STATUS FROM V$DATAFILE

  F. alert notifications in the Enterprise Manager Exadata Plug-In

  Correct Answer: BDF

• Question 62:

  Which two statements are true about metrics in the DBMCLI utility? (Choose two.)

  A. Metric values are computed and stored in memory, and then permanently stored on disk.

  B. DBMCLI can be used to report on Exadata storage server metrics.

  C. Metrics are reported as one of four types: cumulative, instantaneous, rate, or transition.

  D. Fields in AlertHistory cannot be modified.

  E. DBMCLI reported metrics are informational only and cannot be used to trigger alerts or reported events.

  Correct Answer: AC

  Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/app_dbmcli.htm#DBMMN22246

• Question 63:

  What happens in an Exadata Database Machine when the DUPLICATE sub-clause of the INMEMORY attribute is specified?

  A. The DUPLICATE sub-clause enables parallel execution NUMA support.

  B. Each In-Memory Compression Unit in the IM column store will have a mirrored copy placed on another node in the RAC cluster.

  C. The command allows the current instance to exceed DRAM limits and expand across memory, flash, and disk.

  D. The command creates an in-memory snapshot for write_only access.

  E. The In-Memory Compression Unit will have a mirrored copy placed on every other node in the RAC cluster.

  Correct Answer: B

  Reference: http://www.oracle.com/technetwork/database/in-memory/learnmore/twp-dbim-exadata2556211.pdf (page 3)

• Question 64:

  Which statement explains the difference between Normal and High redundancy ASM failure groups?

  A. Normal redundancy protects the DATA diskgroup, whereas High redundancy protects the RECO diskgroup.

  B. Normal redundancy (best practice) provides protection against two simultaneous disk failures, whereas High redundancy provides protection against a single disk failure or an entire storage server failure.

  C. High redundancy gives more usable storage, whereas Normal redundancy provides better I/O performance.

  D. Normal redundancy protects from disk failure when a cell is offline or being updated, whereas High redundancy protects the system when all the cells are offline.

  E. Normal redundancy tolerates a single cell failure, whereas High redundancy tolerates a two-cell failure.

  Correct Answer: E

  Reference: http://blog.umairmansoob.com/tag/using-high-vs-normal-redundancy-in-exadata/

• Question 65:

  There are many different ways to load data into database tables.

  Which method does Oracle strongly recommend?

  A. generic connectivity via ODBC or JDBC

  B. database gateways to open systems and mainframes

  C. Oracle GoldenGate

  D. Oracle Data Pump

  E. SQL*Loader import

  F. data loading via external tables

  Correct Answer: F

• Question 66:

  Which options does not benefit from storage offload processing?

  A. indexes that rely on B-Tree pointers

  B. column filtering

  C. joins and aggregation

  D. table scans

  E. incremental backups with block change tracking

  Correct Answer: A

  Reference: https://www.pythian.com/blog/exadata-join-offloading-in-action/

• Question 67:

  Your customer would like to configure monitoring capabilities alongside ASR on the stand-alone server that was set aside to run ASR Manager.

  What configuration would you set up for the customer?

  A. Enterprise Manager, SQL Developer Server, and ASR Manager on the stand-alone server because ASR needs SQL Developer to gain SQL access to the database server

  B. ASR Manager inside the firewall to ensure that root access to Exadata Database Machine is not compromised

  C. ASR Manager with SNMP traps configured to listen for specific alerts triggered by Exadata Database Machine

  D. Enterprise Manager (Ops Center) and ASR Manager on the stand-alone server because ASR is not a monitoring tool

  Correct Answer: D

• Question 68:

  Identify three customer options for hosting the Platinum Services Advanced Support Gateway. (Choose three.)

  A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

  B. Install in Oracle Virtual Machine with required hardware.

  C. Install on Exadata Engineered System.

  D. Provide individual x86 64-Bit gateway hardware.

  E. Install on Oracle Database Appliance.

  Correct Answer: ABC

  Reference: http://www.oracle.com/us/assets/platinum-services-faq-1653259.pdf

• Question 69:

  Which three tools can be used on a freshly re-imaged Exadata system to create, resize, or delete ACFS filesystems? (Choose three.)

  A. SQL*Plus and ASMCMD

  B. ASMCA

  C. Enterprise Manager Express

  D. Enterprise Manager Cloud Control

  E. RMAN

  F. OUI

  Correct Answer: ABC

  Reference: https://dbasolutions.wikispaces.com/ACFS+on+Linux

• Question 70:

  Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B.

  Which architecture would you suggest to solve this deployment issue?

  A. Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can be used by department B.

  B. Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B.

  C. Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest.

  D. Define the split by setting up database services that are specific to department A and department B.

  Correct Answer: D