Oracle 1z0-338 Online Practice Questions and Exam Preparation

Oracle 1z0-338 Online Questions & Answers

• Question 51:

  Put the full backup and the correct order, if your customer wants to migrate to Exadata.

  A. C, H, D, A, B, F, E, G
  B. C, H, D, A, B, F, G, E
  C. C, H, D, A, E, F, B, G
  D. A, B, C, D, E, F, G, H
  E. Restore the database.
  F. Mount the database.
  G. Recover the database.
  H. Take a full database backup.
  A. C, H, D, A, B, F, E, G

  ---

  Reference: Expert Oracle Exadata By Kerry Osborne, Randy Johnson, Tanel Poder page 452

• Question 52:

  Identify the two choices a customer must make that impact diskgroup creation when the customer wants to have only a DATA diskgroup and a RECO diskgroup? (Choose two.)

  A. the number of databases that will run on the cluster
  B. the OS that will be run
  C. the level of redundancy required
  D. the ratio to use to split the available and usable storage between DATA and RECO
  A. the number of databases that will run on the cluster
  C. the level of redundancy required

• Question 53:

  Oracle ILOM is an embedded service processor in many Oracle Exadata Database Machine components.

  What are three features provided by Oracle ILOM? (Choose three.)

  A. secure access for lights out management of the database and storage servers
  B. web-based, secure shell, IPMI, and SNMP access for out-of-band management
  C. role-based security access to limit functions to individual user administration tasks
  D. storage cell monitoring through the CeIICLI interface
  E. listener access through the back-end management interface for MySQL and SQL Developer
  A. secure access for lights out management of the database and storage servers
  B. web-based, secure shell, IPMI, and SNMP access for out-of-band management
  C. role-based security access to limit functions to individual user administration tasks

  ---

  Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50469/features.htm#DBMSQ21287

• Question 54:

  What are three Oracle recommended methods for migrating to Exadata with the least amount of down time? (Choose three.)

  A. CTAS over a database link
  B. Expdp and Impdp
  C. Cross Platform Incremental Backup and Restore
  D. logical migration by using RMAN and GoldenGate
  E. physical migration by using Data Guard
  C. Cross Platform Incremental Backup and Restore
  D. logical migration by using RMAN and GoldenGate
  E. physical migration by using Data Guard

• Question 55:

  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.
  C. HCC being a database feature will work with all types of storage hardware.

  ---

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

• Question 56:

  Which three items are the main elements of Oracle Database Resource Manager? (Choose three.)

  A. SQL Explain Plan
  B. resource plan
  C. resource consumer group
  D. resource plan directive
  E. IORMPLAN object
  B. resource plan
  C. resource consumer group
  D. resource plan directive

  ---

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/dbrm001.htm#ADMIN11844

• Question 57:

  Which statement is true about the Exadata CELLBOOT USB?

  A. Each patch that is performed on the Exadata storage servers requires manual resync of the CELLBOOT USB.
  B. Some space from the CELLBOOT USB is used for cache metadata when write-back flash cache is enabled.
  C. Regular Exadata storage server patches make sure that the internal USB is updated so that it can be used for recovery.
  D. Exadata automatically copies OS binaries and configuration files from another cell during patching to sync the internal USB.
  E. changes to network configuration files are possible without using ipconf.p1 as long as all the relevant files are updated.
  C. Regular Exadata storage server patches make sure that the internal USB is updated so that it can be used for recovery.

• Question 58:

  Which two statements are true about the two types of Exadata storage servers, the HC storage server and the EF storage server?

  A. The EF storage servers contain 8 X 3.2TB PCIe flash cards.
  B. The HC storage servers contain 12 X 8TB hard disks and 4 X 3.2TB PCI flash cards.
  C. The HC storage server is an all disk storage server with no flash containing 12 X 8TB hard disk.
  D. The EF storage server contains 8 X 3.2TB PCI flash card and can be upgraded with 4 more a total of 12.
  E. The EF storage server contain 8 X 3.2TB PCI flash cards and 4 X 8TB disk drives.
  A. The EF storage servers contain 8 X 3.2TB PCIe flash cards.
  B. The HC storage servers contain 12 X 8TB hard disks and 4 X 3.2TB PCI flash cards.

• Question 59:

  Which two steps are needed to set up instance caging on an Exadata system? (Choose two.)

  A. Set the CPU_COUNT parameter to the maximum number of CPUs that the database instance should utilize at any time.
  B. Enable a resource plan to manage the CPUs.
  C. Specify the optimization objective as low_latency or high__throughput.
  D. Set PGA_AGGREGATE_LIMIT to an acceptable level for the intended instances.
  E. Change the initialization parameter THREADED_EXECUTION to TRUE and restart the instance.
  A. Set the CPU_COUNT parameter to the maximum number of CPUs that the database instance should utilize at any time.
  B. Enable a resource plan to manage the CPUs.

  ---

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

• Question 60:

  You notice that a database node has hung, so you open a Service Request via My Oracle Support.

  What diagnostic output will you send to My Oracle Support by default?

  A. pkginfo
  B. oswatcher
  C. AWR
  D. v$session output
  E. list of database users
  C. AWR