Oracle 1z0-338 Online Practice Questions and Exam Preparation

Oracle 1z0-338 Online Questions & Answers

• Question 21:

  Which two statements are true about migrating your database to Exadata? (Choose two.)

  A. Using Data Guard Physical Standby to migrate from an 11.1 database to Exadata is beneficial because it allows you to adopt HCC during migration.
  B. Because Exadata uses InfiniBand, in order to migrate your database to Exadata, you must have InfiniBand on the system that you are migrating from.
  C. ASM and the database best practice configuration that is supplied during Exadata deployment should be retained during and after migration.
  D. The logical migration methods allow more flexibility in changing the database structure for best performance than the physical methods.
  E. All indexes should be dropped when migrating to Exadata.
  C. ASM and the database best practice configuration that is supplied during Exadata deployment should be retained during and after migration.
  D. The logical migration methods allow more flexibility in changing the database structure for best performance than the physical methods.

  ---

  Reference: http://www.slideshare.net/monowar94ru/migrating-databases-to-exadata-database-machine

• Question 22:

  Which two statement are true about enabling the write-back flash cache?

  A. When enabling the write-back-flash-cache in a rolling manner dbcli should be used to inactivate the grid disks on all cells first.
  B. Before write-back-flash-cache is enabled you need to drop the flash cache first.
  C. Write back flash cache requires a minimum required software version.
  D. When enabling write-back-flash-cache in a non-rolling manners it is important to ensure that asmdeactivationoutcome is set to yes and asmmodestatus is set to online for all grid disks.
  E. flashcachemode should be set to write back by updating cellinit.ora and restarting cellsrv.
  B. Before write-back-flash-cache is enabled you need to drop the flash cache first.
  C. Write back flash cache requires a minimum required software version.

• Question 23:

  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.
  D. Define the split by setting up database services that are specific to department A and department B.

• Question 24:

  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
  A. SQL*Plus and ASMCMD
  B. ASMCA
  C. Enterprise Manager Express

  ---

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

• Question 25:

  Which three mandatory tasks must be performed when configuring the Auto Service Request (ASR) Manager? (Choose three.)

  A. verifying the ASR configuration
  B. registering the ASR Manager
  C. activating a node on the ASR Manager
  D. installing the ASR software on each database server
  E. setting up ASR SNMP traps in Enterprise Manager
  A. verifying the ASR configuration
  B. registering the ASR Manager
  C. activating a node on the ASR Manager

• Question 26:

  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
  B. alert notifications through email when SMTP notification is configured
  D. review of the output of LIST ALERTHISTORY
  F. alert notifications in the Enterprise Manager Exadata Plug-In

• Question 27:

  Which three options describe the flash memory capabilities of the Exadata X6-2 database and storage servers? (Choose three.)

  A. no flash storage on the database server
  B. 4 x 3.2 TB NVMe flash cards on the HC storage server
  C. 8 x 3.2 TB NVMe flash cards on the EF storage server
  D. 4 x 3.2 TB NVMe flash cards on the database server
  E. 8 x 3.2 TB NVMe flash cards on the HC storage server
  A. no flash storage on the database server
  B. 4 x 3.2 TB NVMe flash cards on the HC storage server
  C. 8 x 3.2 TB NVMe flash cards on the EF storage server

• Question 28:

  Your customer wants to load source information into a database. The source files are generated on a remote HP-UX system and need to be written to the Exadata system. The ideal solution would be to use a remote file system where an ACFS file system is exported to the HP-UX system. Which three options are supported using ACFS on Exadata 12.1.0.2 and later?

  A. SAMBA
  B. NFS
  C. HANFS
  D. DBFS
  E. ACFS is not supported on Exadata
  A. SAMBA
  B. NFS
  D. DBFS

• Question 29:

  Which statement is true about instance caging setup?

  A. The initialization parameter resource_manager_plan should be set.
  B. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing.
  C. Database instances need to be restarted to make changes to cpu_count effective.
  D. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
  E. Instance caging is the right approach to make sure that database instances are not stealin memory from one another.
  A. The initialization parameter resource_manager_plan should be set.

  ---

  Reference: http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf

• Question 30:

  Which three features are unique to Exadata Storage? (Choose three.)

  A. grid disks with default AU allocation sizes of 1 MB
  B. usage of flash technology to cache recently used data
  C. prioritization of disk I/Os based on the database
  D. prioritization of OLTP I/Os over scan I/Os
  E. database storage flash cache space allocation guarantees and limits
  A. grid disks with default AU allocation sizes of 1 MB
  C. prioritization of disk I/Os based on the database
  E. database storage flash cache space allocation guarantees and limits