Oracle 1z0-338 Online Practice Questions and Exam Preparation

Oracle 1z0-338 Online Questions & Answers

• Question 31:

  Which three configurations would you recommend to provide High Availability? (Choose three.)

  A. enabling Flashback Technologies - for fast point-in-time recovery from logical corruptions and for fast reinstatement of a primary database following failover
  B. configuring bonding for the management network in order to provide highest availability for the Data Guard network
  C. using Normal redundancy diskgroups for all diskgroups where the primary database is protected by a Data Guard standby database that is deployed on the same Exadata Database Machine
  D. when no Data Guard standby database is deployed, using High redundancy for both the RECO and DATA diskgroups
  E. using Normal redundancy diskgroups for all diskgroups where the primary database is protected by a Data Guard standby database that is deployed on a separate Exadata Database Machine
  F. when no Data Guard standby database is available, configuring Exadata as a stretched RAC
  A. enabling Flashback Technologies - for fast point-in-time recovery from logical corruptions and for fast reinstatement of a primary database following failover
  B. configuring bonding for the management network in order to provide highest availability for the Data Guard network
  D. when no Data Guard standby database is deployed, using High redundancy for both the RECO and DATA diskgroups

• Question 32:

  Which three statements are true about the Enterprise Manager setup in Exadata? (Choose three.)

  A. The Exadata Plug-In is automatically installed with EM Agent 12cR1.
  B. When installing Enterprise Manager after a Platinum Services installation, you should reuse the existing EM Agent.
  C. InfiniBand Switches are monitored remotely.
  D. Enterprise Manager creates a schematic of all servers and their health in the Exadata rack.
  E. Enterprise Manager shows the health of individual ports on the InfiniBand Switches.
  C. InfiniBand Switches are monitored remotely.
  D. Enterprise Manager creates a schematic of all servers and their health in the Exadata rack.
  E. Enterprise Manager shows the health of individual ports on the InfiniBand Switches.

• Question 33:

  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
  D. Enterprise Manager (Ops Center) and ASR Manager on the stand-alone server because ASR is not a monitoring tool

• Question 34:

  How do ASM failure group provide redundancy?

  A. For external redundancy ASM disk groups are placed in a Raid 1+0 configuration to ensure the no blocks are lost during an outage.
  B. They ensure that the ASM disks are accessed via ADB protocol and not physically mounted on the database server.
  C. They assign ASM disks to failure groups to ensure that the mirror copies of a block are not in the same failure group.
  D. They ensure that the cell disks are sliced into grid disks by using cellsrv processes.
  C. They assign ASM disks to failure groups to ensure that the mirror copies of a block are not in the same failure group.

• Question 35:

  Which statement is true about Oracle compression?

  A. A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.
  B. Hybrid Columnar Compression can be defined for a single column.
  C. A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.
  D. A partitioned table can define the use of Advanced Compression Hybrid Columnar Compression for each partition.
  A. A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.

• Question 36:

  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.
  E. The disks in ASM diskgroups must have similar performance characteristics in addition to having the same size.

  ---

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

• Question 37:

  The ipmi tool command is most commonly used to perform which two tasks?

  A. To configure base networking and bonds within the Exadata server.
  B. To power on a chassis from another system in Exadata machine.
  C. To show the ILOM SP server event logs in details for a listing of components status on a particular machine.
  D. To manage and maintain the Exadata storage servers and related cell commands.
  E. To manage cluster components.
  B. To power on a chassis from another system in Exadata machine.
  C. To show the ILOM SP server event logs in details for a listing of components status on a particular machine.

• Question 38:

  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
  B. all the disk headers and storage indexes in the storage cell

• Question 39:

  The Exadata architecture is divided into two specific tiers: the database tier and the storage tier.

  What protocol do these tiers use to communicate with each other?

  A. iDB - Intelligent Database Protocol
  B. InfiniBand protocol
  C. Ethernet protocol
  D. Secure Shell protocol
  E. Fibre Channel protocol
  A. iDB - Intelligent Database Protocol

  ---

  Reference: https://docs.oracle.com/cd/E50790_01/doc/doc.121/e50471/concepts.htm#SAGUG20333

• Question 40:

  Your customer needs to ensure that their data is available on the Exadata machine during patches. The customer wants to be able to patch one server at a time but still be protected against single-node server failure.

  What ASM redundancy level should they use?

  A. High
  B. Normal
  C. External
  D. Extreme
  E. Standard
  B. Normal

  ---

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