Q1. Which two statements are true concerning Oracle 12c Clusterware-managed application VIPs? 

A. If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP isrequired. 

B. An application VIP is created on the default network by the appvipcfg utility. 

C. An application VIP is created on the interconnect network by the crsctl utility. 

D. An application VIP can be created with the crsctl utility. 

E. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails. 

View Answer

Q2. PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open. PROD contains multiple PDBs. 

Examine these successful commands: 

$ srvctl add service –db PROD –pdb PRDPDB1 –service SRVPDB1 $ srvctl start service –db PROD –service SRVPDB1 

Which statement is true about the srvctl start service command? 

A. It opens the PRDPDB1 PDB if not already opened. 

B. It can open the PRDPDB1 PDB only if it is policy managed. 

C. It can open the PRDPDB1 PDB automatically. 

D. It can open the PRDPDB1 PDB only if it is manually managed. 

View Answer

Q3. Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c? 

A. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic StorageManagement (ASM) installation 

B. an O/S group to own the software inventory 

C. an O/S user to own the Oracle Database installation 

D. an O/S group called dba 

E. a group to own the ASMLIB-provisioned storage 

F. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage 

View Answer

Q4. PROD1, PROD2 and PROD3 are three active instances of the PROD database. 

Examine these commands executed on PROD1: 

SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid=’*’; SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid=’PROD1’; 

Which statement is true? 

A. PARALLEL_MIN_SERVERS will be 200 for all instances of PROD. 

B. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD. 

C. The second statement returns an error because this parameter must be identical for all isntances. 

D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1. 

View Answer

Q5. Which two are characteristics of any node that is part of a Grid Plug and Play (GPnP) Domain in Oracle Clusterware? 

A. It has at least two nonroutable interfaces inside the GPnP domain for the private interconnect. 

B. It has at least two routable interfaces outside the GPnP domain for the public interface. 

C. It has at least one routable interface inside the GPnP domain for the private interconnect. 

D. It has at least one routable interface outside the GPnP domain for the public interface. 

E. It has a unique identifier that is unique outside the GPnP domain. 

F. It has a unique identifier that is unique inside the GPnP domain. 

View Answer

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

View Answer

Q7. Which three statements are true regarding Flex ASM on a four-node cluster consisting of 

three-hub nodes and a leaf node? 

A. An ASM instance and database instances can coexist on the same hub node. 

B. A database instance on a hub node can be a client of an ASM instance running on any leaf node. 

C. A database instance on a hub node can be a client of an ASM instance running on any hub node. 

D. A database instance on a leaf node can be a client of an ASM instance running on any hub node. 

E. A database instance on a hub node uses an ASM instance as an I/O server when requesting I/O todiskgroups. 

F. ASM Cluster File System (ASFS) can only be deployed on hub nodes. 

View Answer

Q8. Which three statements are true about Global Resource Management in an Oracle 12c RAC database? 

A. Lazy remastering occurs when an instance shuts with SHUTDOWN IMMEDIATE. 

B. Object remastering causes all blocks in any instances’ buffer cache from the same object to be mastered inthe Global Resource Directory (GRD). 

C. When a database instance fails, then some global resource masters lost from the failing instance areremastered among the surviving instances. 

D. Lazy remastering instances occurs when an instance shuts with SHUTDOWN TRANSACTIONAL. 

E. Global Enqueue resources are recovered after Global Cache Resources after an instance failure. 

View Answer

Q9. You support a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs PDB_1 and PDB_2. 

It runs on an eight-node cluster and a serverpool prod_pool has three servers. Examine these commands executed on HOST01: 

$ srvctl add service –db CDB1 –pdb PDB_1 –service HR –serverpool prod_pool 

$ srvctl start service –db CDB1 –service HR $ srvctl stop service –db CDB1 –service HR 

Which two statements are true? 

A. HR is uniformly managed across all instances in prod_pool. 

B. srvctl stop service only closes PDB_1 in the instance on HOST01. 

C. srvctl stop service closes PDB_1 on all CDB1 instances. 

D. srvctl stop service prevents logins for HR only to CDB1 on HOST01. 

E. srvctl stop service prevents logins to any isntance of CDB1 using service HR. 

F. HR is available on a single instance of prod_pool. 

View Answer

Q10. Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 12c? 

A. All node evictions require that the evicted node or nodes be rebooted. 

B. A node whose performance is severely degraded can be evicted. 

C. The OCSSD process may evict a node after an escalation request from a database instance LMONprocess. 

D. The CSSDMONITOR process can request a node eviction. 

E. The OCLSKD process is used for node eviction requests originating on the node to be evicted. 

F. The reboot advisory broadcasts reboot decisions only over the interconnect. 

View Answer