Oracle 1Z0-485 Online Practice Questions and Exam Preparation

Oracle 1Z0-485 Online Questions & Answers

• Question 31:

  Which CellCLI command is used to conclude that a storage server can be taken offline without impacting database availability?

  A. LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;
  B. LIST CELLDISK ATTRIBUTES name, raidLevel;
  C. LIST CELL ATTRIBUTES cellsrvStatus, flashCacheMode;
  D. LIST CELLDISK ATTRIBUTES name, raidLevel, asmModeStatus;
  E. LIST GRIDDISK ATTRIBUTES name, status;
  A. LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome;

• Question 32:

  What would be the best way to ensure that batch Jobs do not impact performance of online queries that use the same database?

  A. Configure IORM to disable Flash Cache usage for batch workload.
  B. Build a Database Resource Management Plan, giving priority to query workload.
  C. Deploy Instance Caging to control batch jobs.
  D. Configure and enable Parallel Query.
  E. Configure resource plans by using the I/O Resource Manager on the storage cells, giving priority to query workload.
  B. Build a Database Resource Management Plan, giving priority to query workload.

• Question 33:

  Identify two ways to reduce the risks associated with the software updates that are performed on a production Exadata system.

  A. Patch all systems at once instead of one at a time.
  B. Test on an Exadata system that is identical to the production system first.
  C. Updating an engineered system has no risk.
  D. Patch on the standby system first by using Data Guard Standby First Patch Apply.
  E. Create a system-wide firmware and software snapshot first.
  B. Test on an Exadata system that is identical to the production system first.
  D. Patch on the standby system first by using Data Guard Standby First Patch Apply.

• Question 34:

  Which three statements are true about Automatic Degree of Parallelism (Auto DOP) on Exadata?

  A. Auto DOP is an exclusive feature in Exadata, which allows the database optimizer to evaluate each statement and run it in parallel without special hints.
  B. Auto DOP is disabled by default and must be enabled before SQL statements can take advantage of its features.
  C. Auto DOP is enabled by default on Oracle 11gR2, allowing full use of its features.
  D. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on the table's block counts.
  E. SQL statements that take advantage of Auto DOP am be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page.
  B. Auto DOP is disabled by default and must be enabled before SQL statements can take advantage of its features.
  D. Oracle's Auto DOP algorithms calculate the Degree of Parallelism based on the table's block counts.
  E. SQL statements that take advantage of Auto DOP am be identified by using data from Oracle Automatic Workload Repository (AWR) or Enterprise Manager's Monitored SQL Executions page.

• Question 35:

  You are concerned about how to recover from a failed Exadata Storage Server. What is the best way to recover from a storage cell failure when content in both system disks is lost?

  A. Database Machine Administrators should be prepared by creating a backup using dbserver_backup.sh.
  B. Database Machine Administrators should be prepared by creating a backup to an NFS file location as described in the owners guide.
  C. Any USB can be plugged in to create a backup.
  D. Be sure that you have a backup by running make_cellboot_usb.sh in /opt/oracle.cellos.
  E. Use the Exadata Storage Server rescue functionality that Is provided on the CELLBOOT USB flash drive.
  F. Re-imaging the cell is the only option.
  E. Use the Exadata Storage Server rescue functionality that Is provided on the CELLBOOT USB flash drive.

• Question 36:

  In looking to improve query performance for your Data Warehouse, select the best way that Exadata's Flash Cache feature can be leveraged?

  A. Enable Smart Flash Log.
  B. Execute alter table ... cell_flash_cache=keep on heavily scanned tables.
  C. Enable Write Back Flash Cache.
  D. Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.
  B. Execute alter table ... cell_flash_cache=keep on heavily scanned tables.

• Question 37:

  Your customer is hesitant to install the Oracle Configuration Manager in their environment. Give them three ways in which it will benefit their Exsdata Database Machine support experience and potentially resolve some of the issues they are having with the length of time it is taking Oracle to process their Exadata Service Requests (SRs).

  A. Host information can be gathered and sent to Oracle for license compliance.
  B. Potential issues can be addressed before they impact operations.
  C. Priority handling can be extended for SRs, with attached configuration.
  D. Exadata patching cannot be done successfully without the Oracle Configuration Manager.
  E. Root cause analysis can be accelerated.
  B. Potential issues can be addressed before they impact operations.
  C. Priority handling can be extended for SRs, with attached configuration.
  E. Root cause analysis can be accelerated.

• Question 38:

  How does partition pruning, a 11gR2 database feature, help to improve performance on an Exadata Database Machine?

  A. Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.
  B. Using partition pruning can force the optimizer to use that method instead of Smart Scan. Partitioning in Exadata should be used wisely,
  C. Partition pruning is not a supported option in the 11gR2 database code that runs on an Exadata Machine, due to issues with Cost Based Optimizer plans.
  D. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.
  E. Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.
  A. Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.

• Question 39:

  The mpstat output from OS Watcher shows a database node as being 90% idle on an average. What would you do to get a full picture of CPU utilization on the entire Exadata RAC cluster?

  A. Average the mpstat id1 output from all the nodes.
  B. Ask application users if they have noticed a slowdown in screen response.
  C. Look for an increase in batch job servicing times.
  D. A and B above
  A. Average the mpstat id1 output from all the nodes.

• Question 40:

  Which three migration options are available when you migrate a database from the Big Endian format system to Exadata?

  A. Data Pump Export and Import
  B. transportable database
  C. transportable tablespaces
  D. Data Guard
  E. Insert as Select
  B. transportable database
  C. transportable tablespaces
  D. Data Guard