Oracle Oracle Certifications 1z0-338 Questions & Answers

• Question 51:

  Identify two ways that Smart Flash Cache can be enabled on an Exadata Database Machine. (Choose

  two.)

  A. It is enabled through OEDA by selecting the Enable FlashCache check box in the hardware configuration section.

  B. It can be enabled with the ‘cellcli - I alter flashCache=on’command.

  C. It can be enabled manually with the CREATE FLASHCACHEcommand from CellCLI.

  D. It can be enabled by default during installation.

  E. It can be enabled by using the cellCLI DROP FLASHCACHEcommand.

  Correct Answer: CE

• Question 52:

  Which statement is true about the patching features provided in Platinum Services?

  A. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.

  B. Patching support includes Exadata, Exalogic, and Database Appliance.

  C. Patching services are available for the full software stack up to twice per year.

  D. The rolling window and complete down time approaches are two options to patching.

  Correct Answer: C

• Question 53:

  How would you ensure that batch jobs don't impact the performance of online queries that use the same database?

  A. Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workloads.

  B. Configure and enable Parallel Query.

  C. Deploy Instance Caging to control batch jobs.

  D. Build a Database Resource Management Plan, giving priority to query workloads.

  E. Configure IORM to disable Flash Cache usage for batch workloads.

  Correct Answer: D

• Question 54:

  Which statement is true about Hybrid Columnar Compression (HCC)?

  A. HCC is a good choice for LOBs, BLOBs, and CLOBs.

  B. HCC data resides compressed in flash.

  C. HCC being a database feature will work with all types of storage hardware.

  D. HCC is best suited for OLTP type databases with a large number of ongoing transactions.

  Correct Answer: C

  Reference: https://www.dewpoint.com/sites/default/files/images/Dewpoint%20White%20Paper%20-% 20Hybrid%20Columnar%20Compression%20HCC%20Jan2013.pdf

• Question 55:

  Which statement is true about the disks that are used in ASM diskgroups on the Exadata platform?

  A. HP and HC disks can be mixed to any capacity within the same diskgroup.

  B. If High redundancy is selected, grid disks from at least two storage servers must be specified.

  C. In an Exadata storage server, 12 DATA grid disks, 12 RECO grid disks, and 12 DBFS_DG grid disks are configured by default.

  D. The redundancy setting can be changed easily if a wrong choice is made between Normal and High.

  E. The disks in ASM diskgroups must have similar performance characteristics in addition to having the same size.

  Correct Answer: E

  Reference: http://www.oracle.com/technetwork/database/exadata/maa-exadata-asm-cloud-3656632.pdf (page 9)

• Question 56:

  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.

  Correct Answer: CD

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

• Question 57:

  When attempting to install Oracle Enterprise Manager agent software directly on an Exadata storage cell, you get an error.

  What caused the error?

  A. The Enterprise Manager agent software is installed only on the Enterprise Manager repository.

  B. The Enterprise Manager agent software is not a supported version for the storage cell.

  C. Additional software should not be installed on the Exadata storage cell.

  D. The Enterprise Manager agent software should be installed by using the YUM repository.

  Correct Answer: B

• Question 58:

  You are measuring the I/O savings provided by storage indexes for Table A. One of your scripts displays the I/O sayings as a result of the storage indexes.

  Which two statements are true? (Choose two.)

  

  A. The accumulated I/O saved by the storage index is 1.68 MB.

  B. The storage indexes reduced the amount of physical I/O bytes significantly for this query.

  C. Since the database was started, no queries were run against this table with the same predicate.

  D. The storage index data is not on the Cell Server's region index memory structures yet because this predicate has not been used.

  E. The storage indexes were disabled by using the DISABLE_STORAGE_INDEX parameter.

  Correct Answer: BD

• Question 59:

  When backing up a storage cell, what is actually being backed up?

  A. the first two disks in a storage cell that contain the Linux operating system

  B. all the disk headers and storage indexes in the storage cell

  C. the contents of the CELLBOT USB flash drive

  D. the Linux RPM that is used to deploy the storage cell software

  Correct Answer: B

• Question 60:

  To patch an Exadata cloud instance, you need to run the exadbcpatchmulti command as root from the compute node. exadbcpatchmulti uses the exadbcpatch.cfg file to provide information about the location of files related to patching operations as well as additional parameters related to these operations.

  What is the purpose of the sw_bkup_needed=1 parameter that can be set in the exadbcpatch.cfg file?

  A. creates a backup of the patch in case of an error in the patching routine

  B. performs a backup of each Oracle home directory before a patch is applied

  C. forces the software to create a backup of the exadbpatch.cfg file

  D. adds a dialog box that prompts for a backup before the patch can be applied

  E. creates a backup of the Oracle database data files

  Correct Answer: E