Q1. Which two statements are true about database service administration in a RAC environment?
A. When services are created with srvctl, tnsnames.ora is automatically updated.
B. When services are created with srvctl, the service is not started automatically.
C. Service attributes can be modified, unless an instance hosting the service is in restricted mode.
D. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automaticallysynchronized with the changes.
E. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR.
F. When services are started with srvctl, they are automatically added to the data dictionary of the hostingdatabase if not already defined.
Answer: A,E
Q2. Which two statements are true about Quality of Service Management?
A. It can enable a more efficient sharing of hardware resources.
B. It can improve the performance of SQL statements.
C. It can improve system stability as the workload changes.
D. It can improve the performance of PL/SQL.
E. It can reduce the load on the system caused by Oracle background processes.
Answer: A,D
Q3. Which two utilities can be used to predict the consequences of a filesystem failure for the Oracle 12c Clusterware stack?
A. asmcmd
B. srvctl predict....
C. crsctl fail….
D. asmca
E. acfsutil
F. advmutil
Answer: C,E
Q4. Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?
A. In a RAC One Node database, there is no LMD0 process if only one instance is running.
B. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
C. In a RAC database, there is no LMD0 process if only one instance is running.
D. Global Enqueues and Instance Locks replace latches completely in RAC database isntances.
E. Global Enqueues may have owners and waiters in the same instance.
F. Global Enqueues may have converters and waiters in the same isntance.
Answer: E,F
Q5. Which three statements are true concerning activation of a user-defined policy in Oracle
12c Clusterware?
A. When a policy is first created, it is initially active.
B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
C. An administrator-defined policy may be activated using the srvctl utility.
D. When a policy is activated, resources cannot be automatically started to comply with the policy definition.
E. When a policy is first created, it is initially inactive.
F. When a policy is activated, resources can be automatically stopped to comply with the policy definition.
Answer: A,C,E
Q6. Which three statements are true about ASM Cloud File System (ACFS) tagging?
A. asfssettag is a command provided by a platform-independent API to tag files.
B. asfssettag is a command provided by a platform-dependent API to tag files.
C. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.
D. acfsutil encr on can be used to specify the tag names of the files to be encrypted.
E. acfsutil tag set can be used to tag files.
Answer: C,D,E
Q7. You just added an ASM disk to the DATA diskgroup. Which two can be used to monitor the rebalancing?
A. ams_cmd lsop
B. v$asm_disk
C. v$asm_operation
D. v$asm_diskgroup
E. v$session_longops
F. amscmd lsdg
Answer: B,D
Q8. Which three statements are true about the administration and use of policy sets in Oracle 12c Clusterware?
A. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
B. Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used.
C. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS)Management is used.
D. A server pool can have the same attributes defined for different policies in the policy set, when user-definedpolicy management is used.
E. A server pool can have different attributes defined for different policies in the policy set, when user-definedpolicy management is used.
Answer: A,C,E
Q9. 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 the enqueue inexclusive mode.
B. The LMD0 runs only on the instance that masters all GES resources.
C. When a GES resource is dequeued, converters if any exist for that resource, are processed before anywaiter for that resource.
D. The LMD0 process on the requesting instance communicates with the LMD0 process on the masteringinstance if they are not the same instance.
E. The mastering instance for a GES resource is never the same as the instance that owns an enqueue inshared mode.
F. An LMD0 process runs on all instances.
G. The foreground process on the requesting instance communicates with the LMD0 process on themastering instance if they are not the same instance.
Answer: A,F,G
Q10. You plan to apply a patchset to a RAC database running on a two-node cluster.
The cluster has this configuration: Grid infrastructure release 12.1.0.1.0 RAC database release 12.1.0.1.0
All software installed on local file systems
The database is deployed on ASM disk groups.
Examine this list of possible tasks:
Apply the patchset to Grid Infrastructure by installing it in a new location. Stop all database instances.
Apply the database patchset in a new location.
Apply the database patchset on top of the existing ORACLE_HOME.
Start only one database instance in upgrade mode and run the upgrade script.
Start all database instances in upgrade mode and run the upgrade script.
Start all database instances and run the upgrade script. Start all database isntances.
Identify the required tasks in the correct order to apply the patchset with the least amount of down time.
A. 1, 3, 2, 5 and 8 B. 3, 2, 5 and 8
B. 1, 2, 3, 5 and 8
C. 3, 2, 6 and 8
D. 3, 2, 5, 2 and 8
Answer: C