Q1. Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster? 

A. at least one for the public network 

B. at least one for the storage network 

C. at least one for the interconnect 

D. at least two for the public network 

E. at least two for the storage network 

F. at least two for the interconnect 

View Answer

Q2. Examine this command executed on the first node of a three-node cluster: 

# <GRID_INFRASTRUCTURE_ORACLE_HOME>/OPatch/opatchauto apply 18139660 

Which two tasks does this command perform? 

A. It applies a patch to the Grid Infrastructure only on the first cluster mode. 

B. It applies a patch to the Grid Infrastructure on all cluster nodes. 

C. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, onlyon the first cluster node. 

D. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, on allcluster nodes. 

E. It applies a patch to all database ORACLE_HOMEs of any version on the first cluster node. 

F. It applies a patch to all database ORACLE_HOMEs of any version on all cluster nodes. 

View Answer

Q3. Which statement is true about using OPatch to patch Oracle Grid Infrastructure 12c? 

A. All grid infrastructure patches may be applied in a rolling fashion with Opatch. 

B. Opatch can patch all cluster nodes simultaneously without stopping the clusterware on all nodes. 

C. Opatch can patch all cluster nodes simultaneously only for nonrolling patches. 

D. Applying patches with Opatch must be done in an out-of-place fashion. 

View Answer

Q4. Your flex cluster has these attributes: 

1.Hub nodes host01 and host02 

2.Leaf nodes host03 and host04 

3.Full Featured GNS is configured and running. 

You attempt to run this command to add two more nodes to the cluster: 

$ ./addnode.sh –silent “CLUSTER_NEW_NODES={host05,host06}” “CLUSTER_NEW_NODE_ROLES={hub,leaf}” 

What is the result and the reason for this result? 

A. It fails because no VIP was specified for the hub node host05. 

B. It fails because hub and leaf nodes may not be added by the same execution of addNode.sh. 

C. It fails because GNS doesn’t assign VIPs for leaf nodes and no VIP was specified in the command. 

D. It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hubnodes when using full featured GNS. 

View Answer

Q5. Examine this query and output: 

SQL> select order_flag, cache_size, session_flag, keep_value, 

2 from user_sequences where sequence_name = ‘SEQ1’; 

O CACHE_SIZE S K 

-- ---------------- -- -Y 10 N N 

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence. 

The SEQ1 sequence is incremented from all instances equally and is frequently used. 

Which two statements should you execute to reduce SQ enqueue contention? 

A. alter sequence seq1 cache 10000; 

B. alter sequence seq1 order; 

C. alter sequence seq1 noorder; 

D. exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’) 

E. alter sequence seq1 keep; 

View Answer

Q6. Which three statements are true about Oracle Clusterware components, architecture, and behavior? 

A. The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availabilityof cluster resources defined in the Oracle Local Repository file (OLR). 

B. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time. 

C. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining theavailability of the Clusterware stack on a cluster node. 

D. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down. 

E. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing theOracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started. 

F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP). 

View Answer

Q7. 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. 

View Answer

Q8. Which three options have a RAC-specific tuning component? 

A. contention on index leaf blocks 

B. sequence definitions 

C. the size of the online redo log buffers 

D. contention for online redo log files 

E. contention for archived redo log files 

F. the load on the Cluster Interconnect 

View Answer

Q9. Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? 

A. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes. 

B. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed. 

C. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where theDatabase Software will be installed. 

D. Grid infrastructure must be installed on all cluster nodes. 

E. The Clusterware stack must be up on all cluster nodes. 

View Answer

Q10. 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 

View Answer