1Z0-068 Online Practice Questions and Answers

Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?

A. Taking an AWR snapshot in a RAC database captures data from all instances that have the database opened.

B. Taking an AWR snapshot in a RAC database captures data from the local instance only.

C. Data captured by an AWR is aggregated across all instances before being stored in the database.

D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after the top of the hour before taking its AWR snapshot.

E. AWR snapshots are created when control_management_pack_access is set to "none"

Examine this output: ASMCMD> volinfo ?G ACFS

Which statement is true about using OPatch to patch Oracle Grid Infrastructure 12c?

A. All grid infrastructure patches may be applied in a rolling fashion with Opatch.

B. Opatch can patch all cluster nodes simultaneously without stopping the clusterware on all nodes.

C. Opatch can patch all cluster nodes simultaneously only for nonrolling patches.

D. Applying patches with Opatch must be done in an out-of-place fashion.

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 service disruption.

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

D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving 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 leaf nodes, or both.

Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

A. HANFS does not depend on NFS services provided by the underlying operating system.

B. HANFS performance depends on the characteristics of the underlying ASM disks.

C. HANFS provides high availability in case of an NFS client failure.

D. HANFS provides high availability in case of cluster node failure.

E. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem.

Which three statements are true about using ADVM volumes and mounting ACFS file systems from leaf nodes in a Flex Cluster? (Choose three.)

A. Partitioning ADVM-managed volumes using fdisk or other utilities on a leaf node is not supported.

B. An ADVM volume cannot be used as a boot device on a leaf node.

C. To use ADVM volumes, an ASM proxy instance is not required on a leaf node.

D. ADVM volumes can be used to store the OCR and voting files to be used by a leaf node.

E. An ADVM volume cannot be used as the root file system on a leaf node.

F. To use ADVM volumes on a leaf node, the oraclesacfs, oracleoks, and oracleadvm drivers must be loaded on all hub nodes.

Examine this command:

SQL> ALTER TABLESPACE TBS1 ADD DATAFILE '+DATA(newtemplate)/ORCL/USERS/ mytab.dbf' SIZE 100M;

Which two statements are required for this command to succeed? (Choose two.)

A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

B. newtemplate must be defined for the +DATA disk group.

C. Existing data files in TBS1 must also use the same template.

D. The +DATA disk group should not be part of Flex ASM.

E. User-defined subdirectories ORCL and USERS must already exist.

Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 12c? (Choose two.)

A. The Installer permits the creation of a disk group for use by the voting disks and OCR file.

B. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

C. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

D. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

E. ASM disk groups used for voting files and OCR files require a quorum failgroup.

Examine this tnsnames entry from a RAC configuration using a SCAN listener:

HR=(DESCRIPTION=

(LOAD_BALANCE =on)

(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(FORT=1521)) (CONNECT_DATA=(SERVICE_NAME=HRSRV)))

Which two statements are true about clients using this entry to connect? (Choose two.)

A. The host name in the tnsnames entry must be changed if nodes are added or removed from the Cluster.

B. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.

C. Client connection requests are automatically balanced across all IP addresses defined for the SCAN.

D. A client connection request is received by a SCAN listener that creates the connection to the least- loaded database instance.

E. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.

Identify two reasons for the gc current block busy wait event. (Choose two.)

A. A block is busy in the local cache.

B. A block is busy in the remote cache.

C. The Cluster Interconnect is congested.

D. Either the local or remote CPUs have too large a run queue.