Free Oracle 1z0-068 Exam Dumps Questions & Answers

Which three statements are true about fully qualified file names in ASM? (Choose three.)

• A.An alias may be created for an existing le by referring to the fully qualified file name.
• B.They can be used to reference existing ASM files.
• C.They are system generated at the time of ASM file creation.
• D.They can be created only if OMF is enabled.
• E.They are the only valid form that can be used for single file creation of a control file.

You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2, and PDB_3.
You want to drop PDB_3.
Which two statements are true? (Choose two.)

• A.PDB_3 must be closed on all CDB1 instances.
• B.PDB_3 must be open READ ONLY in all CDB1 instances.
• C.Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3.
• D.Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.
• E.CDB1 must be open in restricted mode on all cluster nodes.

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

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

Which three statements are true about the services created when the DBCA is used to create a RAC database?

• A.Singleton services are not permitted for multitenant databases.
• B.They can be administrator managed for a multitenant database.
• C.Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
• D.A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.
• E.They can be policy managed for a multitenant database.

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.
Examine these commands executed on HOST01:
$ srvctl add service -db CDB1 -pdb PDB_1 service AR -serverpool prod_pool -cardinality singleton
$ srvctl start service -db CDB1 -service AR
Which two statements are true regarding the AR service?

• A.AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.
• B.AR is available only on the CDB1 instance on HOST01.
• C.AR is available on any one available CDB1 instance in prod_pool at any one time.
• D.AR can fail over to any other available CDB1 instance in prod_pool.
• E.AR can fail over to any one of the available CDB1 instances.