Q1. 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.
Answer: A,D
Explanation:
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to
11.2 or higher for the disk group.
A high redundancy disk group must contain at least three failure groups.
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG1007
2 https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm
Q2. 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
Q3. Which three statements are true about opatch version 12?
A. It can apply patches to a database ORACLE_HOME.
B. It can apply a patchset to a database ORACLE_HOME.
C. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME.
D. It cannot run with root privileges on a Unix-like system.
E. It can apply some patches without shutting down database instances.
F. It can only apply patches on the cluster node from where it is issued.
Answer: A,D,E
Q4. After creating a RAC One Node database using SQL statements, you want to register this database with Oracle Clusterware as a policy-managed resource.
Which command, or sequence of commands, should you use?
A. srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2 srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron
B. srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2
C. srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron –server016n1, 016n2
D. srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2 srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2
Answer: C
54. Which three statements are true about displaying the location of voting files, OCR files, or OLR files in Oracle Clusterware 12c on a UNIX system?
A. Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM.
B. Use ocrcheck command to view the location of the OCR only if stored in a file system.
C. Use crsctl querry votedisk to view the location of voting files if stored in ASM.
D. Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM.
E. Use crsctl querry votedisk to view the location of voting files if stored in a file system.
F. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system.
Q5. Examine this output: ASMCMD> volinfo – G ACFS –a Diskgroup Name: ACFS Volume Name: VOL1 Volume Device: /dev/asm/vol1-280
State: ENABLED
Size (MB): 2048
Resize Unit (MB): 32
Redundancy: MIRROR
Stripe Columns: 4
Stripe Width (K): 128
Usage: ACFS
Mountpath: /u01/app/grid/acfsmount
The ACFS disk group has 10 GB free space and the file system is currently mounted.
You execute this command to increase the volume size: ASMCMD >volresize –G ACFS –s
3G VOL1
Which statement is true regarding the outcome?
A. It succeeds
B. It fails because the file system must be unmounted before resizing.
C. It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL.
D. It succeeds but the file system is automatically unmounted.
E. It fails because the –f option is not specified.
Answer: C
Q6. 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
Q7. 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
Q8. 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.
Answer: C,D,F
Q9. Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)?
A. Run the crsctl unpin css – host04 command as root on host01, or on either host02 or host03.
B. Run the rootcrs.pl – delete –force command as root on host01, or on either host02 or host03.
C. Run the rootcrs.pl – delete –force command as root on host04.
D. Run the crsctl delete node n – host04 command as root on host04. E. Run the crsctl delete node n – host04 command as root on host04.
E. Run the crsctl delete node n – host04 command as root on host01, or on either host02 or host03.
Answer: B,C
Q10. Which three statements are true about Oracle Clusterware 12c Flex Cluster architecture?
A. Each leaf node must be connected to storage shared across all cluster nodes.
B. Hub nodes require direct access to the voting disks.
C. Each leaf node must be connected to storage shared across all leaf nodes.
D. Each hub node must be connected to storage shared across all hub nodes.
E. Hub nodes require direct access to the OCR file.
F. Leaf nodes require direct access to the voting disks.
Answer: B,C,F