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

certleader.com

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

Answer: C,D 

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

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

Answer: C,E 

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

Answer: A,D 

Q5. Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement? 

A. It cancels pending drops of disks dropped using the DROP DISKGROUP command. 

B. A disk cannot be undropped as a result of a drop diskgroup. 

C. It automatically unmounts the disks after successfully undropping them. 

D. It is not possible to cancel pending drops of disks dropped using the force option. 

Answer: A,C 

Explanation: 

The UNDROP DISKS clause of the ALTER DISKGROUP statement enables you to cancel all pending drops of disks within disk groups. Reference: https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm 

Q6. Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware? 

A. Server Pools must be managed with the crsctl utility for servers hosting an application or otheradministrator-defined high-availability resource. 

B. All servers in a new cluster installation belong to the generic server pool. 

C. The server pool contains servers that host administrator-defined high availability resources. 

D. Server pools must be managed with the srvctl utility for servers hosting a database. 

E. All servers in a new cluster installation belong to the free server pool. 

Answer: B,D,E 

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

Q8. Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 12c? 

A. All node evictions require that the evicted node or nodes be rebooted. 

B. A node whose performance is severely degraded can be evicted. 

C. The OCSSD process may evict a node after an escalation request from a database instance LMONprocess. 

D. The CSSDMONITOR process can request a node eviction. 

E. The OCLSKD process is used for node eviction requests originating on the node to be evicted. 

F. The reboot advisory broadcasts reboot decisions only over the interconnect. 

Answer: B,D,E 

Explanation: Section: (none) Explanation 

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

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

Answer: A,C