Q1. Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?
A. Their COMPATIBLE.ASM attributes must be set to 12.1 or higher.
B. Their COMPATIBLE.ASM attributes must be set to 11.2 or higher.
C. Performance of ACFS is improved by using these diskgroups.
D. Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher.
E. Their sector size attributes can be changed using the ALTER DISKGROUP command.
Answer: B,D
Q2. 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
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. You plan to create a three-instance RAC database stored in ASM, with its data files in the DATA disk group. Identify three supported storage solutions for the Fast Recovery Area (FRA).
A. a shared nothing file system accessed directly by the database instances
B. a cluster file system
C. a shared NFS file system
D. the DATA disk group
E. a local file system with the same path name on each cluster node
Answer: B,D,E
Q5. 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.
Q6. Which four tasks are performed by DBCA when you convert a single-instance database to a four-instance RAC database?
A. creating additional redo threads
B. creating additional undo tablespaces
C. creating shared ASM disk groups
D. adding cluster resources
E. creating database services
F. adding additional initialization parameters
Answer: A,B,C,F
Q7. 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.
Answer: A
Q8. Examine this command:
SQL> CREATE DISKROUP data NORMAL REDANDUNCY:
FAILGROUP fgrpl DISK
‘/dev/disk1’ NAME disk1,
‘/dev/disk2’ NAME disk2,
‘/dev/disk3’ NAME disk3,
FAILGROUP fgrpl2 DISK
‘/dev/disk4’ NAME disk4,
‘/dev/disk5’ NAME disk5,
‘/dev/disk6’ NAME disk6,
FAILGROUP fgrpl3 DISK
‘/dev/disk7’ NAME disk7,
‘/dev/disk8’ NAME disk8,
‘/dev/disk9’ NAME disk9,
ATTRIBUTE ‘au_size’=’4M’,
‘compatible.asm’ = ’11.12’,
‘compatible.rdbms’ = ’11.12’,
‘compatible.advm’ = ’11.12’,
‘content_type’ = ‘recovery’;
Which two statements a true about this disk group, created using Grid Infrastructure 12.1?
A. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failuregroups.
B. File created in this disk group always has two copies for each allocation unit: one primary and onesecondary.
C. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
D. Any database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.
E. The ASM compatible attributes can be changed to 11.1 for this disk group.
Answer: B,E
Q9. 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).
Answer: A,C,E
Q10. Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation?
A. Some grid infrastructure patchsets may not be installed in a rolling fashion.
B. They can be applied in-place.
C. When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of thesoftware running anywhere in the cluster
D. When performing rolling patches, the VIPs for the node being patched are relocated to another node.
Answer: C