Oracle Oracle Certifications 1Z0-485 Questions & Answers

• Question 21:

  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.

  Correct Answer: D

• Question 22:

  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.

  Correct Answer: C

• Question 23:

  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. 100% Real QandAs | 100% Real Pass

  C. DBFS offers tremendous I/O bandwidth.

  Correct Answer: B

• Question 24:

  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.

  Correct Answer: ACE

• Question 25:

  Which statement is true about instance caging setup?

  A. Instance caging is the right approach to make sure that database instances are not stealing memory from each other.

  B. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.

  C. Database instances need to be restarted to make changes to cpu_count effective.

  D. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing

  E. The init.org parameter resource_manager_plan should be set.

  Correct Answer: D

• Question 26:

  Which statement is true about Oracle compression?

  A. A non-partitioned table can use Advanced Compression and Hybrid Columnar Compression concurrently.

  B. A partitioned table can define the use of Advanced Compression or Hybrid Columnar Compression for each partition.

  C. Hybrid Columnar Compression can be defined for a single column.

  D. A partitioned table can use only Advanced Compression or only Hybrid Columnar Compression.

  Correct Answer: CD

• Question 27:

  Which two migration will result in the least down time for a physical or logical migration of a database with active users during the migration?

  A. using GoldenGate

  B. using SQL Developer migration tools

  C. using Data Guard Physical Standby

  D. using cross-platform transportable tablespaces

  E. using incremental cross-platform RMAN restore

  Correct Answer: AE

• Question 28:

  If your customer wants to save storage space by compressing tables that are read frequently but rarely updated, which compression technique would you recommend?

  A. OLTP

  B. ARCHIVE HIGH

  C. QUERY HIGH

  D. ARCHIVE LOW

  E. BASIC

  Correct Answer: B

• Question 29:

  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.

  100% Real QandAs | 100% Real Pass

  

  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.

  Correct Answer: BC

• Question 30:

  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.

  Correct Answer: AC