Q1. Which three statements are true regarding ACFS snapshots in Oracle 12c ASM? 

A. They are contained in a directory on the same volume as their parent file system. 

B. All ACFS snapshot operations for all filesystem are serialized clusterwide. 

C. You can create a snapshot from an existing snapshot. 

D. They can be administered using ASMCMD. 

E. They can only be accessed when the file system is mounted. 

F. They are always point-in-time copies of the parent file system. 

View Answer

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

View Answer

Q3. Examine this command: 

SQl> CREATE DISKROUP RECO HIGH REDUNDANCY: 

FAILGROUP fgrpl1 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’ = ’12.1’, 

‘compatible.rdbms’ = ’12.1’, 

‘compatible.advm’ = ’12.1’, 

‘content_type’ = ‘recovery’; 

Which three statements a true about this disk group? 

A. File created in it have three copies for each allocation unit. 

B. Any database instance with the COMPATIBLE parameter 10.1 and higher can use it. 

C. The Compatible attribute values of the disk group can be changed to lower values. 

D. Files created using a template with the redundancy attributes set to MIRROR will have three-way Mirroring. 

E. The RECO diskgroup may only be used for the FRA. 

F. Files created using a template with the redundancy attribute set to HIGH will have three-way mirroring. 

View Answer

Q4. Which two actions are performed by installing the Oracle 12c Preinstall RPM on Oracle Linux? 

A. It creates the grid user if not already defined. 

B. It modifies the /etc/sysctl.conf Linux file. 

C. It installs kernel modules required for the ASM Cluster File System (ACFS). 

D. It installs the OpenSSH client package. 

E. It creates the oinstall group if not already defined. 

View Answer

Q5. A directory +DATA/ORCL/DATAFILE/USERS exists in ASM. 

USERS is a user created directory; ORCL and DATAFILE are system generated directories. Which two statements are true about user-created directories? 

A. You can create subdirectories under the USERS directory. 

B. You cannot rename a user-created subdirectory. 

C. You cannot drop a directory containing aliases unless you delete the aliases first. 

D. You cannot create a user-defined directory at the root (+) level. 

E. You cannot create a nested subdirectory /USERS/2014 under USERS with a single CREATE DIRETORYcommand even if directory USER1 doesn’t exist. 

View Answer

Q6. The DGRP1 diskgroup has these attributes: 

1.Normal redundancy 

2.Two failgroups with four asmdisks in each failgroup 

3.compatible.asm set to 12.1 

The ASM_POWER_LIMIT is currently set to 1 in the ASM instances. 

There are three databases whose instances are up and which access data in the DGRP1 diskgroup. 

No other clients use this diskgroup. 

You want to add two asmdisks to each failgroup, complete the rebalance as quickly as possible, by avoiding checks for access to allocation units, and then restore database availability. 

Examine the list of actions: 

1.Shut down all database instances using DGRP1. 

2.Shut down all ASM instances. 

3.Add the disks to DGRP1 specifying a large value for the REBALANCE POWER clause. 

4.Start one ASM instances in restricted mode. 

5.Wait for the rebalance to finish. 

6.Mount DGRP1 in restricted mode. 

7.Start all database instances whose files are stored in DGRP1. 

8.Dismount DGRP1. 

9.Mount DGRP1. 

10.Start all ASM instances. 

Identify the correct sequence of required steps: 

A. 1, 2, 3, 4, 5, 2 ,10, 7 

B. 1, 3, 5, 7 

C. 1, 8, 6, 3, 5, 8, 9, 7 

D. 1, 8, 6, 3, 5, 2, 10, 7 

View Answer

Q7. Which two utilities support the “what-if” command evaluation? 

A. asmcmd 

B. ocrconfig 

C. oifcfg 

D. crsctl 

E. srvctl 

View Answer

Q8. Which method can be used to convert a single-instance Oracle 12c Database to a RAC Database? 

A. using DBCA to migrate the database to shared storage and then start one or more RAC databaseinstances on the cluster 

B. using DBCA to create a template from the single-instance database and then to create a RAC database onthe cluster using that template 

C. using the rconfig utility to create a template from the single-instance database and then using DBCA tocreate a RAC database on the cluster using that template 

D. using the rconfig utility to migrate the database to shared storage and then using DBCA to start one ormore RAC database instances on the cluster. 

View Answer

Q9. Which three statements are true about Quality of Service Management (QoS)? 

A. A server-pool can be managed by QoS even if it does have database instances running on nay server inthe pool. 

B. It can manage database services only if they are defined as UNIFORM services. 

C. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running. 

D. It supports multiple databases assigned to the same server pool. 

E. Databases managed by QoS can be administrator managed or policy managed. 

View Answer

Q10. Which two statements are true about ASM alias names? 

A. ASM files created using an alias name are not OMF files even if OMF is enabled. 

B. Alias file names cannot be used together with templates when creating tablespaces. 

C. ASM files created using an alias name are OMF files even if OMF is not enabled. 

D. Alias names can be stored only in user-defined directories. 

E. ASM files created using an alias name also have a fully qualified name and can be accessed by eithername. 

View Answer