Q1. Which three statements are true about Server Categorization in Oracle 12c Clusterware? 

A. All server attributes that may be used to determine the server category are discovered automatically byOracle Clusterware. 

B. Different Hub nodes in a flex cluster may belong to separate administrator-defined categories. 

C. All hub nodes in a flex cluster belong to the same Oracle-supplied category. 

D. A server may be added to only one category using the crsctl utility. 

E. All leaf nodes in a flex cluster belong to the same Oracle-supplied category. 

F. All server attributes used for categorization are administrator modifiable. 

View Answer

Q2. Which three statements are true about Oracle 12 RAC Database software installations? 

A. It is possible to install RAC database software on a one node cluster. 

B. It is possible to install multiple RAC database 12c software homes on the same cluster. 

C. The RAC database 12c software home and Grid infrastructure homes must be owned by separate OSusers. 

D. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RACdatabase software. 

E. The Cluster Verification Utility (CLUVFY) must be used to check the cluster after installing the RACdatabase software. 

F. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OSuser. 

View Answer

Q3. Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners? 

A. It is based on performance metrics provided by the database instances LREG processes. 

B. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing. 

C. The service’s connection load balancing goal must be manually configured to enable server-side connect-time load balancing. 

D. It’s enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client. 

E. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN. 

View Answer

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

Q5. Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware? 

A. There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless ofcluster size. 

B. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters areused. 

C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless ofcluster size. 

D. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository. 

E. The diagcollection.pl script must be run from the Grid home directory as the Grid infrastructure owner. 

F. The clusterware log files are stored inside the Grid Infrastructure Management Repository database usedby the cluster health monitor (CHM). 

View Answer

Q6. Which two statements are true regarding ASM Dynamic Volume manager (ADVM)? 

A. To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must beminimally set to 12.1. 

B. An ADVM volume is individually named and can contain only one file system. 

C. Only one ADVM volume can be created in an ASM disk group. 

D. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group. 

E. File systems contained in ADVM volumes may only contain database files. 

View Answer

Q7. Examine this command to create a volume in the DATA disk group: 

SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH 

STRIPE_WIDTH 1M; 

STRIPE_COLUMNS 1; 

The DATA disk group has 50GB free space. 

Which two are prerequisites for successful execution of this command? 

A. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group. 

B. The DATA disk group must not be created with external redundancy. 

C. The DATA disk group must not contain any other volume. 

D. The DATA disk group must have at least three failure groups. 

E. The DATA disk group must have an AU size of 1MB. 

View Answer

Q8. Which three statements are true about the cluster file system archiving scheme? 

A. Each node can read only the archived logs written by itself. 

B. Nodes don’t use network to archive files. 

C. Each node can read the archive redo log files of the other nodes. 

D. Each node archives to a uniquely named local directory. 

E. Each node archives to a local directory with the same path on each cluster node. 

F. Each node writes to a single location on the cluster file system while archiving the redo log files. 

View Answer

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

Q10. Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster? 

A. The hub node is evicted from the cluster 

B. Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without servicedisruption. 

C. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or moresurviving hub nodes. 

D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or moresurviving leaf nodes. 

E. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes. 

F. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes. 

G. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leafnodes, or both. 

View Answer