Q1. Which two statements are true about v$asm – views in clustered environment? 

A. They exist both in ASM and RDBMS instances, and display the same output. 

B. Their names can be seen in dict when connected to an ASM instance. 

C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started. 

D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on theinstance type. 

E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in thecluster. 

View Answer

Q2. Which three statements are true about node listeners in a Grid Infrastructure Cluster using Flex ASM? 

A. They run from the Grid Infrastructure home by default. 

B. They listen only for database instances on the same node. 

C. They listen only for the ASM instance on the same node. 

D. There only can be one node listener per node. 

E. They listen on behalf on any ASM instance and all database instances on the same node. 

View Answer

Q3. Which three types of patches and upgrades are supported for Oracle Grid Infrastructure 12c? 

A. in-place upgrades using the Oracle Universal Installer 

B. out-of-place patching for patch bundles 

C. in-place patching for patch bundles 

D. out-of-place upgrades using the Oracle Universal Installer 

E. in-place patching for one-off patches 

F. in-place patching for patch sets 

View Answer

Q4. Which two statements are true concerning Oracle 12c Clusterware-managed application VIPs? 

A. If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP isrequired. 

B. An application VIP is created on the default network by the appvipcfg utility. 

C. An application VIP is created on the interconnect network by the crsctl utility. 

D. An application VIP can be created with the crsctl utility. 

E. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails. 

View Answer

Q5. You just added an ASM disk to the DATA diskgroup. Which two can be used to monitor the rebalancing? 

A. ams_cmd lsop 

B. v$asm_disk 

C. v$asm_operation 

D. v$asm_diskgroup 

E. v$session_longops 

F. amscmd lsdg 

View Answer

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

View Answer

Q7. Which two statements are true about initialization parameters for Clustered ASM instances? 

A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect. 

B. ASM_POWER_LIMIT controls he number of RDBMS instances that can access a disk group while it isbeing rebalanced. 

C. The ASM_DISKGROUP parameter is optional. 

D. The default value of INSTANT_TYPE is ASM. 

E. The maximum value of ASM_POWER_LIMIT is 1024. 

View Answer

Q8. Which two statements are true about ASM default templates? 

A. Default data file templates are only created by ASM when a normal redundancy disk group is created. 

B. Default template settings for redundancy depends on the disk group redundancy. 

C. Default templates for a disk group can be modified. 

D. Default template setting for striping depends on disk group redundancy. 

E. Templates may be shared across disk groups. 

View Answer

Q9. Your flex cluster has these attributes: 

1.Hub nodes host01 and host02 

2.Leaf nodes host03 and host04 

3.Full Featured GNS is configured and running. 

You attempt to run this command to add two more nodes to the cluster: 

$ ./addnode.sh –silent “CLUSTER_NEW_NODES={host05,host06}” “CLUSTER_NEW_NODE_ROLES={hub,leaf}” 

What is the result and the reason for this result? 

A. It fails because no VIP was specified for the hub node host05. 

B. It fails because hub and leaf nodes may not be added by the same execution of addNode.sh. 

C. It fails because GNS doesn’t assign VIPs for leaf nodes and no VIP was specified in the command. 

D. It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hubnodes when using full featured GNS. 

View Answer

Q10. Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c? 

A. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic StorageManagement (ASM) installation 

B. an O/S group to own the software inventory 

C. an O/S user to own the Oracle Database installation 

D. an O/S group called dba 

E. a group to own the ASMLIB-provisioned storage 

F. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage 

View Answer