Oracle 1z0-338 Online Practice Questions and Exam Preparation

Oracle 1z0-338 Online Questions & Answers

• Question 1:

  Which two statements appropriately describe the backup and recovery procedures on Exadata? (Choose two.)

  A. The data that is stored in a database is backed up and restored by using CellCLI commands.
  B. The cell software backup is automatic and cell recovery is accomplished by using a rescue procedure.
  C. The database server software backup is automatic and recovery is accomplished by using a rescue procedure.
  D. The data that is stored in a database is backed up and restored by using RMAN commands.
  E. The cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.
  D. The data that is stored in a database is backed up and restored by using RMAN commands.
  E. The cell software backup is performed through CellCLI and cell recovery is accomplished by using a rescue procedure.

• Question 2:

  Which characteristics of DBFS on Exadata would you suggest as being a key benefit?

  A. When using DBFS customers will not need to use FUSE or any client software to administer the file system.
  B. DBFS offers tremendous I/O bandwidth.
  C. Tens of thousands of files are the perfect use case for DBFS on Exadata.
  D. DBFS in an Exadata environment is faster than an NFS mount system because of smart scan performance gain.
  E. DBFS allow customer to store LOB and CLOB files external to database for more flexibility.
  C. Tens of thousands of files are the perfect use case for DBFS on Exadata.

• Question 3:

  Identify three customer options for hosting the Platinum Services Advanced Support Gateway. (Choose three.)

  A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
  B. Install in Oracle Virtual Machine with required hardware.
  C. Install on Exadata Engineered System.
  D. Provide individual x86 64-Bit gateway hardware.
  E. Install on Oracle Database Appliance.
  A. Purchase the recommended x86 64-Bit gateway hardware from Oracle.
  B. Install in Oracle Virtual Machine with required hardware.
  C. Install on Exadata Engineered System.

  ---

  Reference: http://www.oracle.com/us/assets/platinum-services-faq-1653259.pdf

• Question 4:

  Which options does not benefit from storage offload processing?

  A. indexes that rely on B-Tree pointers
  B. column filtering
  C. joins and aggregation
  D. table scans
  E. incremental backups with block change tracking
  A. indexes that rely on B-Tree pointers

  ---

  Reference: https://www.pythian.com/blog/exadata-join-offloading-in-action/

• Question 5:

  Consider the following software changes that are performed manually on a Linux server:

  1.

  Changes for Linux kernel firewall configuration

  2.

  Changes for custom performance monitoring tools

  3.

  Changes for security scan tools

  4.

  Changes for Linux system performance optimization

  Which of the software changes listed are permitted on Exadata Storage Servers?

  A. only 3
  B. 1, 2, 3, and 4
  C. none
  D. only 2
  E. only 1 and 2
  F. only 2 and 3
  E. only 1 and 2

• Question 6:

  Which statement is true about Enterprise Manager 12c for Exadata?

  A. EM Agents are installed on each database and storage node.
  B. EM Agents should not be installed on Exadata. Remote monitoring is the best practice.
  C. EM Agents can communicate to storage cells via SSH.
  D. The Exadata Plug-In for monitoring switches is installed in each EM Agent.
  E. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.
  C. EM Agents can communicate to storage cells via SSH.

  ---

  Open SSH Ports

  The Enterprise Manager Cloud Control 12c Agents require ssh access to the Exadata Database Machine components they monitor. As the Agents will run on the compute nodes the ssh ports, 22, on each of the storage cells, ILOMs, PDUs,

  KVMs, InfiniBand switches, and Cisco switch will need to be opened for each of the compute nodes.

• Question 7:

  In which three ways can customers access the ILOM interface to manage the Exadata database and storage server hardware components? (Choose three.)

  A. ILOM CLI interface through the management network
  B. ILOM Web interface through the management network
  C. remote KVM session to the ILOM
  D. from the database server operating system tool "ilomcli"
  E. from the storage server operating system tool "ilomcli"
  B. ILOM Web interface through the management network
  C. remote KVM session to the ILOM
  E. from the storage server operating system tool "ilomcli"

• Question 8:

  A cloud user is assigned the Service Administrator role.

  Which cloud actions can this user perform?

  A. Perform all tasks in the My Services application, including user and role management tasks.
  B. View, create, update, and delete Oracle Compute Cloud Service resources.
  C. View only the Oracle Compute Cloud resources.
  D. Work with one or more Oracle Cloud services only and use the My Services application to manage his or her own password and security challenge questions.
  E. Perform cloud backups of a specific instance.
  B. View, create, update, and delete Oracle Compute Cloud Service resources.

  ---

  Reference: https://docs.oracle.com/cloud/latest/computecs_common/OCSUG/GUID-F89D66BD-85F5- 4325-8A1F-F8EEE53A7CF1.htm#OCSUG113

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

  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.