1Z0-068 Online Practice Questions and Answers

Which three statements are true about ASM Cloud File System (ACFS) encryption?

A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.

B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.

C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.

D. acfsutil encr on can be used to specify the encryption key length for a directory or file.

E. An ACFS snapshot can be ACFS encrypted.

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.

Examine this query and output:

SQL> select order_flag, cache_size, session_flag, keep_value, 2 from user_sequences where sequence_name = `SEQ1';

O CACHE_SIZE S K

Y 10 N N

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.

The SEQ1 sequence is incremented from all instances equally and is frequently used.

Which two statements should you execute to reduce SQ enqueue contention?

A. alter sequence seq1 cache 10000;

B. alter sequence seq1 order;

C. alter sequence seq1 noorder;

D. exec sys.dbms_shared_pool.keep (`SEQ1', `Q')

E. alter sequence seq1 keep;

Which two statements are true about resources defined by an administrator and registered with Oracle 12c Clusterware for high availability?

A. A policy-managed resource can be started manually using crsctl.

B. A policy-managed resource can be started manually using srvctl.

C. Resource dependencies are automatically set when using a policy-managed resource.

D. An administrator-managed resource can be started manually using crsctl.

E. An administrator-managed resource can be started manually using srvctl.

F. The action script is automatically set when using a policy-managed resource.

Which three statements are true concerning activation of a user-defined policy in Oracle 12c Clusterware?

A. When a policy is first created, it is initially active.

B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.

C. An administrator-defined policy may be activated using the srvctl utility.

D. When a policy is activated, resources cannot be automatically started to comply with the policy definition.

E. When a policy is first created, it is initially inactive.

F. When a policy is activated, resources can be automatically stopped to comply with the policy definition.

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 the software running anywhere in the cluster

D. When performing rolling patches, the VIPs for the node being patched are relocated to another node.

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

View the Exhibit.

Which three statements are true? (Choose three.)

A. The three listed disks may have previously belonged to a disk group.

B. The three listed disks may already be members of an existing disk group.

C. To allow an 11g R2 database to use this disk group, ASM Compatibility must be 11.2 or lower.

D. The COMPATIBLE parameter of any database client using this disk group can be less than or equal to 12.1.

E. ADVM compatibility can be set greater than or equal to 11.2 without changing the value of ASM compatibility.

F. The three listed disks are have definitely not been provisioned using ASMLIB.

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 only for PROD1.

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

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

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

Which three statements are true concerning backups of the OCR and OLR in Oracle Clusterware 12c? (Choose three.)

A. The OCR can be backed up using ocrconfig.

B. The OCR is backed up automatically every four hours.

C. The OCR is backed up by default to a cluster file system location.

D. The OLR can be backed up using ocrconfig.

E. The OLR is backed up automatically every four hours.

F. The OLR is backed up by default to a cluster file system location.