Oracle 1Z0-485 Online Practice Questions and Exam Preparation

Oracle 1Z0-485 Online Questions & Answers

• Question 11:

  Which Exadata feature uses Flash as a parallel write cache to Disk Controller Cache?

  A. Exadata DRAM
  B. InfiniBand network cache
  C. high performance SAS disks
  D. Smart Flash Log
  E. Hybrid Columnar Compression
  D. Smart Flash Log

• Question 12:

  Which two attributes describe key benefits of the InfiniBand network?

  A. All Exadata database servers have a direct path link to each Exadata Storage Server.
  B. Cell-to-cell communication uses Reliable Datagram Sockets (RDS) over InfiniBand to achieve low latency.
  C. Expanding from two Full racks to four only requires adding an external InfiniBand switch to be at the top of the fat-tree topology.
  D. Each InfiniBand link provides 10 Gigabits of bandwidth.
  E. Oracle's interconnect protocol uses direct memory access (DMA) to eliminate buffer copies and reduce CPU use.
  C. Expanding from two Full racks to four only requires adding an external InfiniBand switch to be at the top of the fat-tree topology.
  E. Oracle's interconnect protocol uses direct memory access (DMA) to eliminate buffer copies and reduce CPU use.

• Question 13:

  Consider this CellCLI command:

  CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;

  Which two statements describe what happens when you execute this command?

  A. It creates one 423 GB grid disk on the first available cell hard disk.
  B. It creates one 423 GB grid disk on each available cell hard disk.
  C. It creates grid disks on the outermost 423 GB that is available on each hard disk.
  D. It creates grid disks on the innermost 423 GB that is available on each hard disk.
  E. It creates an Exadata Smart Flash Cache on all flash drives.
  B. It creates one 423 GB grid disk on each available cell hard disk.
  C. It creates grid disks on the outermost 423 GB that is available on each hard disk.

• Question 14:

  You are concerned about how recovery from a failed Exadata Storage Server would work. Which statement is true about the Exadata CELLBOOT USB?

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

• Question 15:

  Your customer has purchased their brand new Exadata Database Machine X3-2 Full rack to achieve 20- TB-per-hour backups on their 300 TB database. You have been called to determine why they are not able to achieve even half that rate. Use the information in the image below to identify two reasons their backups are still slow.

  

  A. LVM snapshots are not configured properly on the Database Server.
  B. The Media Server to Tape Library transfer is causing a bottleneck.
  C. The number of tape drives is causing a bottleneck.
  D. Exadata backups are being performed using RMAN over the 10 Gigabit Ethernet network.
  E. The number of database servers is causing a bottleneck.
  B. The Media Server to Tape Library transfer is causing a bottleneck.
  C. The number of tape drives is causing a bottleneck.

• Question 16:

  Your customer would like to use DBFS in their Exadata environment. They are asking you for the key characteristic of DBFS on Exadata.

  A. DBFS in an Exadata environment is faster than an NFS mount system because of the Smart Scan performance gains.
  B. Tens of thousands of files are the perfect use case for DBFS on Exadata.
  C. DBFS offers tremendous I/O bandwidth.
  B. Tens of thousands of files are the perfect use case for DBFS on Exadata.

• Question 17:

  What are three ways to be informed of an Exadata Storage Server disk failure?

  A. review of the output of LIST ALERTHISTORY
  B. review of the output of SELECT STATUS FROM VSDATAFILE
  C. review of the ILOM log
  D. alert notifications through email when SMTP notification is configured
  E. alert notifications in the Enterprise Manager Exadata Plug-In
  F. review of database server iostat output
  A. review of the output of LIST ALERTHISTORY
  D. alert notifications through email when SMTP notification is configured
  E. alert notifications in the Enterprise Manager Exadata Plug-In

• Question 18:

  What are the three customer options for hosting the Platinum Services Advanced Support Gateway?

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

• Question 19:

  Identify two reasons why using external tables for high performance data loads on Exadata is more advantageous than SQL*Loader.

  A. Transformations can be applied directly on the file data using SQL or PL/SQL constructions.
  B. External tables allow transparent parallelization inside the database.
  C. Parallelizing loads with external tables enables more efficient space management.
  D. External tables can take advantage of storage indexes to speed up data loads.
  C. Parallelizing loads with external tables enables more efficient space management.

• Question 20:

  Which table compression technique will not work on Exadata without licensing the Oracle Advanced Compression Option?

  A. COMPRESS
  B. COMPRESS BASIC
  C. COMPRESS FOR OLTP
  D. COMPRESS FOR QUERY
  E. COMPRESS FOR ARCHIVE
  C. COMPRESS FOR OLTP