1Z0-068 Online Practice Questions and Answers

Which three statements are true about node listeners in a Grid Infrastructure Cluster using Flex ASM?

A. They run from the Grid Infrastructure home by default.

B. They listen only for database instances on the same node.

C. They listen only for the ASM instance on the same node.

D. There only can be one node listener per node.

E. They listen on behalf on any ASM instance and all database instances on the same node.

Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?

A. They are contained in a directory on the same volume as their parent file system.

B. All ACFS snapshot operations for all filesystem are serialized clusterwide.

C. You can create a snapshot from an existing snapshot.

D. They can be administered using ASMCMD.

E. They can only be accessed when the file system is mounted.

F. They are always point-in-time copies of the parent file system.

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.

Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

A. The software must be installed into a cluster file system.

B. The software must be installed into a local file system on each node.

C. RAC installations require Oracle Enterprise Edition.

D. Fix-up scripts generated during the installation must be run as root on UNIX platforms.

E. The software can be installed into an ACFS file system.

F. The software must be installed on all nodes in the cluster.

G. SSH user equivalence for the Oracle user can be set up before the software installation.

Which three resources are managed using global concurrency control in an Oracle 12c RAC multi- instance database? (Choose three.)

A. latches

B. enqueues

C. database block buffers

D. mutexes

E. cursors

F. redo log buffers

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

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

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

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

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

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

Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 12c? (Choose two.)

A. The Installer permits the creation of a disk group for use by the voting disks and OCR file.

B. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

C. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

D. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

E. ASM disk groups used for voting files and OCR files require a quorum failgroup.

You created a RAC database with DBCA and decide to verify it.

The server pool large_db has four servers.

Examine the output shown:

Which two statements are true based on this output? (Choose two.)

A. The sales database resource will be started and the database instances will be started automatically when restarting the clusterware stack after normal shutdown of the sales database.

B. The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database.

C. The sales database resource will be restarted automatically after an instance failure.

D. The concurrency values are not shown because sales in not a RAC One Node database.

E. The concurrency values are not shown because sales has only one of its four instances running.