1Z0-068 | The Secret of Oracle 1Z0-068 pdf


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

Answer:

Q32. Which two statements are true about Flex ASM in a Flex Cluster? 

A. Oracle databases from releases older than 12c cannot use Flex ASM. 

B. ASFS may only be configured on a hub node running an ASM instance. 

C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM. 

D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database andASM instance placement in a cluster. 

E. Hub nodes with connections from multiple leaf nodes must run an ASM instance. 

Answer: A,E 

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

Q34. When using Oracle 12 Clusterware, which two actions are required to repair the ocr.loc file on host01 in a cluster having three other nodes called host02, host03, and host04? 

A. Run ocr.config –repair on another node in the cluster to repair the ocr.loc file on host01 

B. Stop the clusterware stack on host01 only. 

C. Stop the clusterware stack on all cluster nodes. 

D. Run ocrconfig –repair on host01. 

E. Stop the clusterware stack on host01 and on the node used to issue the ocrconfig –repair command. 

Answer: B,C 

Q35. 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:

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

Answer: B,C,E 

Explanation: 

All Oracle ACFS snapshot operations are serialized clusterwide in the kernel. you chose to create a snapshot image on an existing snapshot group, select a snapshot group from the existing snapshot group table (make sure you select a snapshot group that has not reached its maximum limit of snapshot images). 

Before you can access the files on a file system, you need to mount the file system. 

Reference: https://docs.oracle.com/database/121/OSTMG/GUID-5A3EF695-A795-4FEA-8BE2AF657BD2238C.htm#OSTMG33000 

http://mysupport.netapp.com/NOW/public/eseries/amw/index.html#page/ 

SANtricity_v11.20_Array_Management_Window_Help/create_PIT_image.html (Creating a 

Snapshot image 3rd point, 1st line). 

https://docs.oracle.com/cd/E19455-01/805-7228/6j6q7ueup/index.html (1st paragraph, 1st line). 

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

Answer: E,F 

Q38. Which three statements are true about Oracle Enterprise Manager Topology Viewer? 

A. It displays which listeners listen on behalf of which instances. 

B. It displays the relationship between targets of different target types in a cluster. 

C. It displays the status of all cluster components. 

D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB). 

E. It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM. 

F. It displays the type of network used by RAC database instance. 

Answer: A,C,D 

Q39. Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster? 

A. The hub node is evicted from the cluster 

B. Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without servicedisruption. 

C. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or moresurviving hub nodes. 

D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or moresurviving leaf nodes. 

E. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes. 

F. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes. 

G. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leafnodes, or both. 

Answer: D,F,G 

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

Answer: C,E