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 Quality of Service Management (QoS)?

A. A server-pool can be managed by QoS even if it does have database instances running on any server in the pool.

B. It can manage database services only if they are defined as UNIFORM services.

C. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.

D. It supports multiple databases assigned to the same server pool.

E. Databases managed by QoS can be administrator managed or policy managed.

Which four tasks are performed by DBCA when you convert a single-instance database to a four-instance RAC database?

A. creating additional redo threads

B. creating additional undo tablespaces

C. creating shared ASM disk groups

D. adding cluster resources

E. creating database services

F. adding additional initialization parameters

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 statements are true about Oracle Clusterware components, architecture, and behavior?

A. The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availability of cluster resources defined in the Oracle Local Repository file (OLR).

B. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time.

C. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node.

D. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down.

E. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing the Oracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started.

F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).

Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c?

A. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic Storage Management (ASM) installation

B. an O/S group to own the software inventory

C. an O/S user to own the Oracle Database installation

D. an O/S group called dba

E. a group to own the ASMLIB-provisioned storage

F. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage

Which two statements are true about clustered ASM instances? (Choose two.)

A. An ASM instance must store its SPFILE in ASM.

B. The ASM passwordfile can be stored in $GRID_HOME/dbs on local storage of a cluster node.

C. The ASM passwordfile can be stored in a diskgroup that is accessible to all ASM instances.

D. The SPFILE must be stored in $GRID_HOME/dbs on local storage of a cluster node.

E. The SPFILE must be stored in a diskgroup that is accessible to all ASM instances.

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.

Which three statements are true concerning the behavior of an Oracle Clusterware 12c Flex Cluster in response to hub or leaf node failures? (Choose three.)

A. Leaf nodes evicted from a Flex Cluster always require a reboot.

B. Hug node eviction results in the reboot of all leaf nodes that were connected to the evicted hub node.

C. Hub nodes evicted from a Flex Cluster always require a reboot.

D. Hub node eviction results in the eviction of all leaf nodes that were connected to the evicted hub node.

E. Cluster Resources on a leaf node that is evicted from a Flex Cluster are relocated, if possible, to another leaf node that is connected to same hub node to which the failed leaf node was connected.

F. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to a leaf node that was connected to the evicted hub node.

G. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to another hub node in the cluster.