Oracle 1Z0-485 Online Practice Questions and Exam Preparation

Oracle 1Z0-485 Online Questions & Answers

• Question 61:

  What are two impacts of selecting high redundancy over normal redundancy for your diskgroups?

  A. High redundancy provides more usable storage.
  B. Normal redundancy provides more usable storage.
  C. High redundancy gives you better I/O performance.
  D. High redundancy provides High Availability (HA) during disk failure and rolling Storage Server patching
  E. Normal redundancy provides HA during rolling Storage Server patching.
  B. Normal redundancy provides more usable storage.
  D. High redundancy provides High Availability (HA) during disk failure and rolling Storage Server patching

• Question 62:

  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
  B. ARCHIVE HIGH

• Question 63:

  A customer has three databases named CC. FIN, and DW. The CC database is for their CallCenter. Even a slight decrease in the response time of the database would mean more people "on hold" in their data center. The orders received through the CallCenter are stored in the Finance (FIN) database. Both databases, CC and FIN, serve as sources for the Data Warehouse (DW) database. All databases use the same Automatic Storage Management (ASM) diskgroup and therefore, the same physical disks on Exadata storage. The customer wants to dynamically control the resources that are available for the CallCenter database because this has direct impact on their operations? Which option should be implemented?

  A. DBRM on the CC database
  B. DBRM on all the databases
  C. IORM, because DBRM cannot be changed for an existing session
  D. IORM and DBRM
  B. DBRM on all the databases

• Question 64:

  Consider the following setup:

  User A1 belongs to resource group High on Database A.

  User B2 belongs to resource group Low on Database B.

  User C3 is a user on Database C without any DBRM setup.

  DBRM setup:

  Database A: Resource group High gets 80% and Low gets 20%.

  Database B: Resource group High gets 60% and Low gets 40%.

  IORM setup:

  Database A: Share=20, limit=5

  Database B: Share=30, limit=10

  Database C: 5 shares

  Total number of shares in the IORM setup = 100

  What percent of I/O will each database user theoretically be using when the Exadata storage unit I/O throughout is used 100% and no other databases but A, B, and C are running?

  A. Al = 36%, B2=18%, and C3=9%
  B. Al = 33%, B2=33%, and C3=33%
  C. AI = 10%, B2=5%, and C3=20%
  D. Al = 8%, B2=12%, and C3=5%
  E. Al = 5%, B2=10%, and C3=85%
  E. Al = 5%, B2=10%, and C3=85%

• Question 65:

  When running OS Watcher, which two data outputs are valid for Exadata storage cell performance analysis? Select the two correct choices that apply?

  A. lostat
  B. mpstat
  C. netstat
  D. pkginfo
  E. label
  A. lostat
  C. netstat

• Question 66:

  Identify the correct steps required to upgrade a 1/8th rack of Exadata to a 1/4th rack.

  A. Remove the doors of the 1/8th rack. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack.
  B. Activate all cores by using a software command. Activate all hard drives and flash drives. Create the grid disks. Expand the Oracle ASM diskgroups. Review the new configuration.
  C. Remove the doors of the 1/8th rack. Add an additional Sun Datacenter InfiniBand Switch. Add the new servers. Cable the Database Servers in the rack. Cable the Exadata Storage Servers in the rack. Close the rack. Configure the new hardware.
  D. Activate all cores by using a software command. Activate all hard drives and flash drives.
  B. Activate all cores by using a software command. Activate all hard drives and flash drives. Create the grid disks. Expand the Oracle ASM diskgroups. Review the new configuration.

• Question 67:

  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
  A. using GoldenGate
  E. using incremental cross-platform RMAN restore

• Question 68:

  When an Exadata Storage Server hard disk failure alert is received, what manual action must you take to restore the system to full redundancy?

  A. Replace the disk and run MegaCLI to rebuild the degenerate mirror.
  B. No manual action is required because Automatic Storage Management (ASM) fast mirror resync is automatic
  C. No manual action is required because ASM rebalancing is automatic.
  D. Replace the disk and manually copy the mirror extents to the new drive.
  E. Run RMAN REPAIR FAILURE.
  C. No manual action is required because ASM rebalancing is automatic.

• Question 69:

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

• Question 70:

  High-disk IOPS (I/Os per second) rates are leading to longer execution times. Which three approaches would you use to improve this scenario?

  A. Enable Write-Back Flash Cache due to heavy DBWR usage.
  B. Enable Write-Back Flash Cache due to heavy LGWR usage.
  C. Swap hard disks to High Capacity disks.
  D. Tune the application to reduce I/O requests.
  E. Leverage IORM to give priority to critical workloads.
  B. Enable Write-Back Flash Cache due to heavy LGWR usage.
  D. Tune the application to reduce I/O requests.
  E. Leverage IORM to give priority to critical workloads.