Free 1Z0-068 Exam Dumps

Question 36

Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC?

A. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
B. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed.
C. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database Software will be installed.
D. Grid infrastructure must be installed on all cluster nodes.
E. The Clusterware stack must be up on all cluster nodes..

Correct Answer:DE

Question 37

Which three file types can be stored in an ASM Cluster file system (ACFS) and used by the relevant software? (Choose three.)

A. Oracle Cluster Registry (OCR) files
B. Oracle database executables
C. Grid Infrastructure executables
D. Data files for tablespaces
E. Archive logs
F. Voting Disks

Correct Answer:BDE

Question 38

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

Correct Answer:BCD
There are special considerations for choosing a location for the flash recovery area in a RAC environment. The location must be on a cluster file system, ASM or a shared directory configured through NFS. The location and disk quota must be the same on all instances.
References: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup005.htm

Question 39

Which two statements are tuning recommendations for RAC database? (Choose two.)

A. Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query.
B. Use sequences with CACHE and ORDER, if possible.
C. Use Locally Managed Tablespaces with large uniform extent sizes.
D. Use Locally Managed Tablespaces with autoallocate.
E. Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing.
F. Use sequences with CACHE and NOORDER, if possible.

Correct Answer:DF

Question 40

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.

Correct Answer:BD