Q1. Examine the output of this command: ASMCMD> volinfo –G ACFS -a Diskgroup Name: ACFS Volume Name: VOL1 Volume Device: /dev/asm/vol1-280 State: ENABLED Size (MB): 248 Resize Unit (MB): 32 Redundancy: MIRROR Stripe Columns: 4 Stripe Width (K): 128 Usage: ACFS Mountpath: /u01/app/grid/acfsmount The ACFS disk group is a normal redundancy disk group with 5 GB of free space. To increase the size of the ACFS file system, you execute this command as the root user: $ /sbin/acfsutil size +200M /u01/app/grid/acfsmount 

Which two statements are true regarding the outcome of this command? 

A. It resizes VOL1. 

B. It fails to resize the filesystem because it must be unmounted before resizing. 

C. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group. 

D. It succeeds but leaves the filesystem unmounted. 

E. It resizes the filesystem mounted on /u01/app/grid/acfsmount. 

View Answer

Q2. Which three components are integral parts of High Availability NFS (HANFS)? 

A. Application VIP 

B. DHCP 

C. ExportFS 

D. HAVIP 

E. NFS 

F. HAIP 

View Answer

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

View Answer

Q4. Which three statements are true about the services created when the DBCA is used to create a RAC database? 

A. They can be policy managed for a multitenant database. 

B. Singleton services are not permitted for multitenant databases. 

C. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that usesthat server-pool for a service. 

D. Policy-managed services specified for a database allow the creation of a new server pool using DBCA. 

E. They can be administrator managed for a multitenant database. 

View Answer

Q5. PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open. PROD contains multiple PDBs. 

Examine these successful commands: 

$ srvctl add service –db PROD –pdb PRDPDB1 –service SRVPDB1 $ srvctl start service –db PROD –service SRVPDB1 

Which statement is true about the srvctl start service command? 

A. It opens the PRDPDB1 PDB if not already opened. 

B. It can open the PRDPDB1 PDB only if it is policy managed. 

C. It can open the PRDPDB1 PDB automatically. 

D. It can open the PRDPDB1 PDB only if it is manually managed. 

View Answer

Q6. Which three statements are true about the administration and use of policy sets in Oracle 12c Clusterware? 

A. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used. 

B. Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used. 

C. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS)Management is used. 

D. A server pool can have the same attributes defined for different policies in the policy set, when user-definedpolicy management is used. 

E. A server pool can have different attributes defined for different policies in the policy set, when user-definedpolicy management is used. 

View Answer

Q7. Which two statements are true about database service administration in a RAC environment? 

A. When services are created with srvctl, tnsnames.ora is automatically updated. 

B. When services are created with srvctl, the service is not started automatically. 

C. Service attributes can be modified, unless an instance hosting the service is in restricted mode. 

D. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automaticallysynchronized with the changes. 

E. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR. 

F. When services are started with srvctl, they are automatically added to the data dictionary of the hostingdatabase if not already defined. 

View Answer

Q8. A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections. 

Broken connections must be re-established as quickly as possible. Which feature will support this requirement? 

A. Fast Connection Failover (FCF) with Transparent Application Failover (TAF) 

B. Transparent Application Failover (TAF) 

C. Transparent Application Failover (TAF) using Fast Application Notification (FAN) 

D. Fast Connection Failover (FCF) 

View Answer

Q9. Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC? 

A. In a RAC One Node database, there is no LMD0 process if only one instance is running. 

B. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances. 

C. In a RAC database, there is no LMD0 process if only one instance is running. 

D. Global Enqueues and Instance Locks replace latches completely in RAC database isntances. 

E. Global Enqueues may have owners and waiters in the same instance. 

F. Global Enqueues may have converters and waiters in the same isntance. 

View Answer

Q10. When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)? 

A. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster 

B. using Shared GNS running on another cluster 

C. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster 

D. creation of a new GNS for this cluster 

E. using DHCP to assign Node Virtual IP addresses for nodes in the cluster 

View Answer