Online Access Free 1Z0-058 Exam Questions

You notice that there is a very high percentage of wait time for the 'enq:HW-contention' event in your RAC database that has frequent insert operations.
Which two recommendations may reduce this problem?

• A.using reverse key indexes
• B.increasing sequence cache sizes
• C.uniform and large extent sizes
• D.smaller extent sizes
• E.shorter transactions
• F.automatic segment space management

You want to check an ACFS for consistency on the Linux platform. Which command-line tool would you use to do this?

• A.fdisk
• B.advmutil
• C.asmcmd
• D.fsck
• E.acfsutil

You want to reorganize the DATA diskgroup while continuing database operations. The DATA diskgroup was created using normal redundancy having one disk per failure group. The two disks used are /dev/sdal and /dev/sda2.
You plan to drop the existing disks and add the /dev/sdb1 and /dev/sdb2 disks to failure group FG_C and the /dev/sdcl and /dev/sdc2 disks to failure group FG_D.
Which procedure would you use to minimize the effect of the I/Os of this reorganization on ongoing database operations?

• A.Set rebalance power to 0 for diskgroup DATA
  Drop disks /dev/sdal and /dev/sdb disks.
  Add failure group FG_C with all the /dev/sdb disks.
  Add failure group FG_D with all the /dev/sdc disks
  Set rebalance power to 1 for diskgroup DATA.
• B.Set rebalance power to 9 for diskgroup DATA. Add failure group FG_C with all the /dev/sdb disks.
  Add failure group FG_D with all the /dev/sdc disks.
  Drop disks /dev/sda1 and /dev/sda2.
  Set rebalance power to 0 for diskgroup DATA.
• C.Set rebalance power to 0 for diskgroup DAT
  Add failure group FG_C with all the /dev/sdb disks.
  Add failure group FG_D with all the /dev/sdc disks.
  Drop disks/dev/sda1 and /dev/sda2.
  Set rebalance power to 1 for diskgroup DATA.
• D.Set rebalance power to 0 for diskgroup DATA.
  Add failure group FG_C with all the /dev/sdb disks.
  Add failure group FG_D with all the /dev/sdb disks.
  Drop disks/dev/sda1 and /dev/sda2.
  Set rebalance power to 9 for diskgroup DATA.

You notice that there is a very high percentage of wait time for the gc current split event in your RAC database that has frequent insert operations.
Which two recommendation would you make to reduce this problem?

• A.increasing sequence cache sizes
• B.uniform and large extent sizes
• C.using hash partitioned global indexes
• D.smaller extent sizes
• E.shorter transactions
• F.automatic segment space management

You want to install a database patch on your eight-node cluster by using Opatch with, the minimum amount of down time to your cluster nodes.
You have already been prompted for the first set of nodes and you replied with node names RACNODE1 RACNODE2, and RACNODE3.
Which two statements are true about the procedure for minimizing down time?

• A.When the first set of nodes has been patched, the instances on the remaining nodes are shut down automatically by opatch.
• B.The patch must be propagated to, applied, and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.
• C.The instances must be started on the first set of nodes and then stopped on the remaining set to make certain that some nodes are always available.
• D.When the first set of nodes has been patched, the administrator is prompted to shut down the instances on the remaining nodes.
• E.The patch must be propagated to and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.