Online Access Free 1z0-068 Exam Questions

Examine this command:
$ srvctl modify service -db RACDB -service SRVBl -clbgoal LONG
This three-Instance RAC database uses Flex ASM.
Which two statements are true regarding server-side connect-time load balancing using SCAN listeners for this service? (Choose two.)

• A.It is disabled because the -c1bgoal attribute is set to LONG.
• B.The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.
• C.The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.
• D.It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.
• E.The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.

Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true?

• A.The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
• B.The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
• C.Clusterware will monitor the service while it is active.
• D.When manually started, the service will always start on one or more available instances rather than on their preferred instances.
• E.The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.

Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC?

• A.The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
• B.When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.
• C.An LMD0 process runs on all instances.
• D.The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.
• E.The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
• F.The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.
• G.The LMD0 runs only on the instance that masters all GES resources.

You plan to use DBCA to convert a single-instance Oracle 12c database on a local filesystem on a stand-alone server to RAC by using ASM.
You installed Grid Infrastructure 12c on a four-node cluster.
Examine this list of possible conversion steps:
1. Create a template and image les from the single-instance database by using DBCA.
2. Perform an RMAN backup of the single-instance database.
3. Validate the cluster using CLUVFY.
4. Copy the template and image les to a cluster node.
5. Restore the RMAN backup to the recovery area disk group on the cluster.
6. Perform an Oracle Database 12c RAC installation.
7. Create a RAC database with DBCA using the RMAN backup.
8. Create a RAC database with DBCA using the template.
Which statement correctly lists the minimum steps required to perform the conversion?

• A.2, 5, 7
• B.2, 3, 5, 7
• C.1, 3, 4, 6, 8
• D.1, 4, 8
• E.2, 5, 6, 7
• F.1, 4, 6, 8

Examine this output:

The ACFS disk group has 10 GB free space and the file system is currently mounted.
You execute this command to increase the volume size:
ASMCMD >volresize -G ACFS -s 3G VOL1
Which statement is true regarding the outcome?

• A.It fails because the file system must be unmounted before resizing.
• B.It succeeds but the file system is automatically unmounted.
• C.It succeeds.
• D.It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL.
• E.It fails because the -f option is not specified.