Online Access Free 1Z0-058 Practice Test

Which interconnect design is NOT supported for Oracle Clusterware?

• A.multiple switch design
• B.redundant interconnect design
• C.single switch design
• D.crossover cable design

Which three statements ate true about services and Transparent Application Failover (TAF)?

• A.The TAF setting for a client connection overrides any TAF setting in the service definition.
• B.If TAF has been configured for a service, sessions using that service fail over to a surviving instance when an outage occurs.
• C.Services simplify the deployment of TAF because by defining a TAF policy for a service, all connections using this service will automatically have TAF enabled.
• D.The TAF setting on a service can be NONE, BASIC, PRECONNECT, or POSTCONNECT, and overrides any TAF setting in the client connection definition.
• E.TAF can restart a query after failover has completed but for other statements, such as INSERT, UPDATE, or DELETE, the application must resubmit the transaction.

Which three statements are true about ASM dynamic volume manager (ADVM)?

• A.To use the ADVM driver, the oraclesacfs, oradeoks, and oracleadvm drivers must be loaded, but an ASM instance is not required.
• B.The administrator can use ADVM to create volumes that contain bootable vendor operating systems.
• C.ADVM provides volume management services and a standard disk device driver interface to file system drivers.
• D.File systems and other disk-based applications issue I/O requests to ADVM volume devices as they would to other storage devices on a vendor operating system.
• E.ADVM extends ASM by providing a disk driver interface to storage backed by an ASM volume.

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 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.
• C.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.
• D.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.

How does the Oracle Grid Infrastructure administrator determine the location of the Oracle Clusterware voting disk?

• A.Run srvctl query css votedisk from any node.
• B.Run select name, path from v$votedisk from any RAC database instance of any database on the cluster.
• C.Run crsctl query css votedisk from any node.
• D.Run cat /etc/oracle/vote.loc from any node.