Oracle 1z1-068 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z1-068
Exam Name/Title: Oracle Database 12c: RAC and Grid Infrastructure Administrator
Certification Provider: Oracle
Corresponding Certification: 12c

Exam Questions: 152
Updated On: Jul 07, 2026

Question #56

Examine this tnsnames entry from a RAC configuration using a SCAN listener:
HR=(DESCRIPTION=
(LOAD_BALANCE =on)
(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(PORT=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. Client connection requests are automatically balanced across all IP addresses defined for the SCAN.

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

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

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

Discussion 0

Correct Answer: C,D Vote an answer

Question #57

Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners?

A. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.

B. It is based on performance metrics provided by the database instances LREG processes.

C. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN.

D. It's enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.

E. The service's connection load balancing goal must be manually configured to enable server-side connect-time load balancing.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #58

Which three statements are true about fully qualified file names in ASM? (Choose three.)

A. They are the only valid form that can be used for single file creation of a control file.

B. They can be used to reference existing ASM files.

C. They are system generated at the time of ASM file creation.

D. They can be created only if OMF is enabled.

E. An alias may be created for an existing le by referring to the fully qualified file name.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #59

Which three components are integral parts of High Availability NFS (HANFS)?

A. NFS

B. Application VIP

C. HAVIP

D. DHCP

E. HAIP

F. ExportFS

Discussion 0

Correct Answer: A,C,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #60

A clustered ASM Instance has the DATA diskgroup mounted.
Which two can be used to display information about databases accessing files in the DATA diskgroup?

A. v$asm_client

B. asmcmd lsdg

C. v$session

D. v$process

E. asmcmd lsct

Discussion 0

Correct Answer: A,E Vote an answer

Question #61

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. They can be administrator managed for a multitenant database.

C. Singleton services are not permitted for multitenant databases.

D. Policy-managed services specified for a database allow the creation of a new server pool using DBCA.

E. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.

Discussion 0

Correct Answer: A,B,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #62

You are administering an ORACLE RAC database with multiple instances.
Examine this command executed from the PROD1 instance which succeeds:
CREATE SPFILE FROM MEMORY;
Which statement is true?

A. An SPFILE is created and contains parameter settings for all instances.

B. An SPFILE is created for each instance and contains parameter settings for all instances.

C. An SPFILE is created and contains parameter settings only for PROD1.

D. An SPFILE is created for each instance containing instance-specific parameter settings only.

Discussion 0

Correct Answer: D Vote an answer

Question #63

You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)

A. The ACFS mount registry with Oracle restart is automatically deleted.

B. The ACFS file system will be permanently removed from the volume.

C. The disabling of volume does not destroy data in the file system.

D. The ACFS le system will be permanently removed from the volume only if the file system is empty.

E. The volume can be enabled and the le system can be mounted back again to access the existing data.

Discussion 0

Correct Answer: C,E Vote an answer

Question #64

Which two statements are true regarding ASM Dynamic Volume manager (ADVM)?

A. An ADVM volume is individually named and can contain only one file system.

B. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

C. To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.

D. Only one ADVM volume can be created in an ASM disk group.

E. File systems contained in ADVM volumes may only contain database files.

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #65

Which three statements are true about services when used with transparent application failover (TAF) for an administrator-managed RAC database?

A. TAF-settings for the service override TAF settings in TNS entry used by the client.

B. TAF PRECONNECT requires configuration for the service and in the client TNS entry.

C. The TAF settings for a client connections overrides any TAF settings in the service definition.

D. TAF-enabled sessions fail over to a surviving instance accepting logins for the service.

E. TAF can restart a query or a transaction after failover.

Discussion 0

Correct Answer: A,B,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #66

Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)

A. They are used to coordinate access across multiple library caches for anonymous PL/SQL execution.

B. They are used to coordinate access across multiple library caches for the same stored procedure.

C. They are used to coordinate the next value for a sequence created with the CACHE and ORDER clauses.

D. They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses.

E. They are used when an application uses the DBMS_LOCK package for UL lock types.

Discussion 0

Correct Answer: B,C Vote an answer

Download Free Oracle 1z1-068 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-068 exam.