Oracle 1z0-338 Online Practice Questions and Exam Preparation

Oracle 1z0-338 Online Questions & Answers

• Question 1:

  Which statement is true about High Availability (HA) in an Exadata environment?

  A. When a standby database is in place, DB_BLOCK_CHECKING is not required and thus is not recommended.
  B. The checksums that are performed on the Exadata Storage Server ensure logical consistency of the block content.
  C. Stretched RAC is the best alternative for Exadata that combines both HA and DR into one.
  D. Due to the different architecture that Exadata has with storage servers when compared to regular Storage Area Network, DB_LOST_WRITE_PROTECT need not be set.
  E. The Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.
  E. The Oracle Exadata Storage Server Software HARD checks operate transparently after enabling DB_BLOCK_CHECKSUM on a database.

• Question 2:

  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

  ---

  explanation:

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

• Question 3:

  Identify three default ways to connect to Oracle Exadata Cloud Service that is running on Oracle Public Cloud.

  A. using the UNIX-based telnet command
  B. using SQL *Net from clients that are running on a compute cloud service
  C. using SSH for administrative purposes
  D. using Oracle Net from on-premise applications
  E. using the Remote Desktop client and the RDP protocol
  B. using SQL *Net from clients that are running on a compute cloud service
  C. using SSH for administrative purposes
  D. using Oracle Net from on-premise applications

  ---

  explanation:

  Reference: https://www.oracle.com/webfolder/technetwork/tutorials/Architecture_Diagrams/ecs_arch/ ecs_arch.html

• Question 4:

  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 5:

  Your customer would like to install security software on all systems that are hosted out of their datacenter. Which statement correctly identifies Oracle guide line on where security software can be installed on Exadata?

  A. The security software can be installed on the database server or a storage cells as long as the software is certified for Oracle enterprise Linux.
  B. The security software can be installed on the database server or storage cells as required.
  C. The security software can be installed on database server but not on the storage cell.
  D. The security software can be installed on database server but not on the storage cells unless the software is explicitly certified for Oracle enterprise Linux.
  C. The security software can be installed on database server but not on the storage cell.

• Question 6:

  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 7:

  Which three statements describe the memory capabilities of the X6-2 Exadata system?

  A. The database server come with 256GB memory default.
  B. The database server can contain 768GB memory.
  C. The HC and EF storage servers contain 128GB memory.
  D. The database server come with 512GB memory by default.
  E. The HC and EF server come with 512GB memory default.
  A. The database server come with 256GB memory default.
  B. The database server can contain 768GB memory.
  C. The HC and EF storage servers contain 128GB memory.

• Question 8:

  When a customer use Enterprise Manager to monitor and maintain their Exadata machine, which protocol does enterprise manager uses to send and receive information about component failure event and status.

  A. ILOM
  B. ICMP
  C. RPC
  D. IPMI
  E. SNMP
  E. SNMP

• Question 9:

  Where would your customer go to find the latest Exadata patches?

  A. My Oracle support for database patches, ULN for OS patches and SUN Support for servers and InfiniBand patches.
  B. The Exadata owner guide.
  C. The patch database in my Oracle support.
  D. My Oracle Support note 888828.1.
  E. The database machine in Exadata storage server 11g release 1 (11.1) supported version (Doc ID: 835032.1).
  D. My Oracle Support note 888828.1.

• Question 10:

  Which three steps should you perform before executing the following command which will set the cell flash cache mode to write back? # cellcli -e alter cell flashcachemode=writeback

  A. Inactivate all physical disks on the cell.
  B. Shutdown the cellsrv services on the cell.
  C. Disable the storage indexes on the cell.
  D. Inactivate the grid disks on the cell.
  E. Create a new flash cache on the cell.
  F. Drop the existing flash cache on the cell.
  B. Shutdown the cellsrv services on the cell.
  D. Inactivate the grid disks on the cell.
  F. Drop the existing flash cache on the cell.