Q1. Examine the output of the asmcmd and srvctl commands:
$ asmcmd showclustermode
ASM cluster : Flex mode enabled $ srvctl status asm –detail ASM is running on host01,
host03 ASM is enabled.
$ srvctl config asm
ASM home: /u01/app/12.1.0/grid
Password file: +DATA/orapwASM
ASM listener: LISTENER
ASM instance count: 2
Cluster ASM listener: ASMNET1LSNR_ASM Then you execute this command:
$ srvctl relocate asm – currentnode host03 –targetnode host02
Which three statements are true regarding the execution of this command based on the
output shown?
A. It fails because an ASM instance is not configured to run on HOST02.
B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST02.
D. It fails because the ASM instance has not been shut down first on HOST03.
E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut downuntil all connected clients disconnected.
F. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST01.
Answer: C,E,F
Q2. Which two statements are true about Flex ASM in a Flex Cluster?
A. Oracle databases from releases older than 12c cannot use Flex ASM.
B. ASFS may only be configured on a hub node running an ASM instance.
C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.
D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database andASM instance placement in a cluster.
E. Hub nodes with connections from multiple leaf nodes must run an ASM instance.
Answer: A,E
Q3. Which three are benefits of using RAC One Node in Oracle 12c?
A. automatic failover for high availability
B. ability to perform rolling patches
C. online conversion from RAC One Node databases to multi-instance RAC databases
D. load-balancing of services within a single instance
E. online-conversion from non-RAC databases to RAC One Node databases
F. multiple instances of the same database on a single node to protect against instance failure
Answer: B,D,F
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.
Answer: B
Q5. Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c?
A. the Grid Naming Service (GNS) VIP
B. public IP addresses
C. High Available VIP (HAIP) addresses
D. Single Client Access Name (SCAN) VIPs
E. Storage Network IP addresses
Answer: C,D
Q6. 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.
Answer: A,C,F
Q7. 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
Q8. Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?
A. An XCUR block image may exist for a specific database block in only one instance.
B. A CR image may get served from one instance to another to satisfy a read request.
C. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occurfor updated rows on the block.
D. A PI block image may exist for a specific database block in only one instance.
Answer: A,D
Q9. Which three components are integral parts of High Availability NFS (HANFS)?
A. Application VIP
B. DHCP
C. ExportFS
D. HAVIP
E. NFS
F. HAIP
Answer: B,C,E
Q10. 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.
Answer: C,E,F