Free 1Z0-068 Exam Dumps

No Installation Required, Instantly Prepare for the 1Z0-068 exam and please click the below link to start the 1Z0-068 Exam Simulator with a real 1Z0-068 practice exam questions.
Use directly our on-line 1Z0-068 exam dumps materials and try our Testing Engine to pass the 1Z0-068 which is always updated.

Exam Code: 1Z0-068
Exam Title: Oracle Database 12c: RAC and Grid Infrastructure Administration
Vendor: Oracle
Exam Questions: 152
Last Updated: July 3rd,2024

Question 1

Examine this command and output:
[root@host01 ~]# / sbin/acfsutil snap create snap001 /u0l/app/grid/acfsmount/ acfsutil snap create: Snapshot operation is complete.
Examine this command:
[root@host01 ~]# / sbin/acfsutil snap create –p snap001 Snap002 /u01/app/grid/ acfsmount/
Which statement must be true for the successful execution of the second command?

A. The disk group compatibility attribute for ADVM must be set to 12.1 or higher.
B. The parent snapshot must be read-only.
C. The underlying ADVM volume must be configured with high redundancy.
D. The parent snapshot must be read/write.

Correct Answer:C

Question 2

Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)?

A. Run the crsctl unpin css – host04 command as root on host01, or on either host02 or host03.
B. Run the rootcrs.pl – deconfig –force command as root on host01, or on either host02 or host03.
C. Run the rootcrs.pl – deconfig –force command as root on host04.
D. Run the crsctl unpin css -n host04 command as root on host04
E. Run the crsctl delete node -n host04 command as root on host04.
F. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.

Correct Answer:CF
To delete a node from a cluster:
References: https://docs.oracle.com/database/121/CWADD/adddelclusterware.htm#CWADD90992

Question 3

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

A. TAF-enabled sessions fail over to a surviving instance accepting logins for the service.
B. TAF-settings for the service override TAF settings in TNS entry used by the client.
C. TAF can restart a query or a transaction after failover.
D. The TAF settings for a client connections overrides any TAF settings in the service definition.
E. TAF PRECONNECT requires configuration for the service and in the client TNS entry.

Correct Answer:ABC
A: SESSION failover. When the connection to an instance is lost, SESSION failover results only in the establishment of a new connection to another Oracle RAC node; any work in progress is lost. SESSION failover is ideal for online transaction processing (OLTP) systems, where transactions are small.
C: SELECT failover. With SELECT failover, Oracle Net keeps track of all SELECT statements issued during the transaction, tracking how many rows have been fetched back to the client for each cursor associated with a SELECT statement. If the connection to the instance is lost, Oracle Net establishes a connection to another Oracle RAC node and re-executes the SELECT statements, repositioning the cursors so the client can continue fetching rows as if nothing has happened. The SELECT failover approach is best for data warehouse systems that perform complex and time-consuming transactions.
D: Oracle's answer to application failover is a new Oracle Net mechanism dubbed Transparent Application Failover. TAF allows the DBA to configure the type and method of failover for each Oracle Net client.

Question 4

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

Correct Answer:CD

Question 5

Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 12c for a standard cluster when using Full Featured Grid Naming Service (GNS).

A. You must create a Grid Management Repository database.
B. You must enable the Name Server Cache Daemon (NSCD).
C. ADHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
D. Each cluster node must have at least two network interface cards,
E. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
F. ADHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

Correct Answer:CEF