1Z0-068 Exam - Oracle Database 12c: RAC and Grid Infrastructure Administration

certleader.com

Q1. Which three statements are true about the cluster file system archiving scheme? 

A. Each node can read only the archived logs written by itself. 

B. Nodes don’t use network to archive files. 

C. Each node can read the archive redo log files of the other nodes. 

D. Each node archives to a uniquely named local directory. 

E. Each node archives to a local directory with the same path on each cluster node. 

F. Each node writes to a single location on the cluster file system while archiving the redo log files. 

Answer: A,C,D 

Explanation: 

Each node can read the logs written by itself and any other node. Each node can read the archived redo log files of the other nodes. Each node archives to a uniquely named local directory. 

Reference: https://docs.oracle.com/cd/E18283_01/rac.112/e16795/rman.htm https://docs.oracle.com/cd/E11882_01/rac.112/e41960/rman.htm#RACAD320 

https://www.google.com.pk/url? 

sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwjfpsutmZjLAh UMcI4KHQl-

DDUQFggaMAA&url=https%3A%2F%2Fdocs.oracle.com%2Fcd%2FE11882_01%2Frac.1 12%2Fe41960% 2Frman.htm&usg=AFQjCNF54ysmEZx1uyl4UreB_aBSP3HoFA&sig2=03a0bvImDDXv3hS vLi18Uw 

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 two are characteristics of any node that is part of a Grid Plug and Play (GPnP) Domain in Oracle Clusterware? 

A. It has at least two nonroutable interfaces inside the GPnP domain for the private interconnect. 

B. It has at least two routable interfaces outside the GPnP domain for the public interface. 

C. It has at least one routable interface inside the GPnP domain for the private interconnect. 

D. It has at least one routable interface outside the GPnP domain for the public interface. 

E. It has a unique identifier that is unique outside the GPnP domain. 

F. It has a unique identifier that is unique inside the GPnP domain. 

Answer: C,E 

Q4. Which three statements are true about ASM Cloud File System (ACFS) encryption? 

A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory. 

B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors. 

C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges. 

D. acfsutil encr on can be used to specify the encryption key length for a directory or file. 

E. An ACFS snapshot can be ACFS encrypted. 

Answer: A,D,E 

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

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

Answer: A,C,D 

Q7. You plan to apply a patchset to a RAC database running on a two-node cluster. 

The cluster has this configuration: Grid infrastructure release 12.1.0.1.0 RAC database release 12.1.0.1.0 

All software installed on local file systems 

The database is deployed on ASM disk groups. 

Examine this list of possible tasks: 

Apply the patchset to Grid Infrastructure by installing it in a new location. Stop all database instances. 

Apply the database patchset in a new location. 

Apply the database patchset on top of the existing ORACLE_HOME. 

Start only one database instance in upgrade mode and run the upgrade script. 

Start all database instances in upgrade mode and run the upgrade script. 

Start all database instances and run the upgrade script. Start all database isntances. 

Identify the required tasks in the correct order to apply the patchset with the least amount of down time. 

A. 1, 3, 2, 5 and 8 B. 3, 2, 5 and 8 

B. 1, 2, 3, 5 and 8 

C. 3, 2, 6 and 8 

D. 3, 2, 5, 2 and 8 

Answer:

Q8. Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster? 

A. at least one for the public network 

B. at least one for the storage network 

C. at least one for the interconnect 

D. at least two for the public network 

E. at least two for the storage network 

F. at least two for the interconnect 

Answer: D,E 

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

Answer: A,B,E 

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