oracle 1z0-068 practice test

Question 1

Examine this tnsnames entry from a RAC configuration using a SCAN listener:
HR=(DESCRIPTION=
(LOAD_BALANCE =on)
(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(FORT=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. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.
• C. Client connection requests are automatically balanced across all IP addresses defined for the SCAN.
• D. A client connection request is received by a SCAN listener that creates the connection to the least-loaded database instance.
• E. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.

Answer:

B D

Question 2

Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at
system boot on the local node? (Choose two.)

• A. crsctl stop crs
• B. crsctl stop cluster
• C. crsctl disable crs
• D. crsctl config crs

Answer:

A C

Question 3

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?

• A. In a RAC One Node database, there is no LMD0 process if only one instance is running.
• B. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
• C. In a RAC database, there is no LMD0 process if only one instance is running.
• D. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
• E. Global Enqueues may have owners and waiters in the same instance.
• F. Global Enqueues may have converters and waiters in the same instance.

Answer:

A F

Explanation:
F: A convert queue is a queue of locks that are waiting to be converted to particular mode, this is the process of changing a
lock from one mode to another, even a NULL is a lock. A resource has a lock value block (LVB). The Global Resource
Manager (GRM) keeps the lock information valid and correct across the cluster. Oracle 10g release 2 and beyond replaced
some latch mechanisms with the mutex approach, claiming that they are faster and more efficient than traditional locking
mechanisms.
Incorrect Answers:
B, D: Mutexes are objects that exist within the operating system to provide access to shared memory structures. They are
similar to latches. References:
http://www.datadisk.co.uk/html_docs/rac/grd.htm

Question 4

For which three entities can the what-if command evaluation be used to determine the impact of clusterware management
operations in Oracle 12c Clusterware? (Choose three.)

• A. Pluggable Databases (PDBs)
• B. administrator-defined resources
• C. local resources
• D. database transactions
• E. cluster resources

Answer:

A B E

Question 5

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

• A. Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM.
• A. The Installer permits the creation of a disk group for use by the voting disks and OCR file.
• B. Use ocrcheck command to view the location of the OCR only if stored in a file system.
• 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. Use crsctl querry css votedisk to view the location of voting files if stored in ASM.
• C. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
• D. Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM.
• D. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
• E. Use crsctl query css votedisk to view the location of voting files if stored in a file system.
• E. ASM disk groups used for voting files and OCR files require a quorum failgroup.
• F. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system.

Answer:

D,E

Question 6

View the Exhibit.

Which three statements are true? (Choose three.)

• A. It applies a patch to the Grid Infrastructure only on the first cluster node.
• A. The three listed disks may have previously belonged to a disk group.
• B. It applies a patch to the Grid Infrastructure on all cluster nodes.
• B. The three listed disks may already be members of an existing disk group.
• C. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, only on the first cluster node.
• C. To allow an 11g R2 database to use this disk group, ASM Compatibility must be 11.2 or lower.
• D. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, on all cluster nodes.
• D. The COMPATIBLE parameter of any database client using this disk group can be less than or equal to 12.1.
• E. It applies a patch to all database ORACLE_HOMEs of any version on the first cluster node.
• E. ADVM compatibility can be set greater than or equal to 11.2 without changing the value of ASM compatibility.
• F. It applies a patch to all database ORACLE_HOMEs of any version on all cluster nodes.
• F. The three listed disks are have definitely not been provisioned using ASMLIB.

Answer:

D,E,F

Question 7

Which three statements are true about Oracle Flex ASM? (Choose three.)

• A. Oracle databases from releases older than 12c cannot use Flex ASM.
• A. It always requires a Flex cluster.
• B. ACFS may only be configured on a hub node running an ASM instance.
• B. Only three ASM instances are supported in Flex ASM.
• C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.
• C. The SPFILE and password file for ASM are stored by default an ASM disk group.
• D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database and ASM instance placement in a cluster.
• D. An ASM instance can run on a leaf node.
• E. Hub nodes with connections from multiple leaf nodes must run an ASM instance.
• E. A designated network is used for communication between ASM instances and theirclients.
• F. ASM clients can fail over to other ASM instances.

Answer:

C,E,F

Question 8

Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement?
(Choose two.)

• A. surviving node failures
• A. It cancels pending drops of disks dropped using the DROP DISKGROUP command.
• B. surviving storage network failures
• B. ASM disks can never be undropped as a result of a DROP DISKGROUP.
• C. surviving interconnect failures
• C. It automatically unmounts the disks after successfully undropping them.
• D. automatic workload management for services on local connections
• D. Disks must be rebalanced manually after successfully undropping them.
• E. automatic workload management for services on Oracle Net connections
• E. It is not possible to cancel pending drops of disks dropped using the force option.
• F. parallel execution across all instances supporting a balanced policy-management service
• G. parallel execution across all instances supporting a singleton policy-management service

Answer:

B,E

Question 9

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

• A. They are used when an application uses the DBMS_LOCK package for UL lock types.
• A. A server pool directive override can be used to modify the database parameter CPU_COUNT for all databases within one server pool.
• B. They are used to coordinate the next value for a sequence created with the CACHE and ORDBR clauses.
• B. It requires a resource manager plan to be active on databases managed by QoS.
• C. They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses.
• C. It supports RAC One Node databases if they are assigned to server pools with a maximum size of one server.
• D. They are used to coordinate access across multiple library caches for the same stored procedure.
• D. One QoS policy can span multiple clusters if they contain server pools, assigned to be managed by QoS.
• E. They are used to coordinate access across multiple library caches for anonymous PL/SQL execution.
• E. The command-line utility qosct1 can be used to change the password of the internal user QOSADMIN.

Answer:

B,C,E

Question 10

Which three are among the minimum components in a software image that is part of a Grid Plug and
Play (GPnP) profile in Oracle Clusterware? (Choose three.)

• A. in-place upgrades using the Oracle Universal Installer
• A. an operating system version
• B. out-of-place patching for patch bundles
• B. a version of Oracle database server used in Real Application Cluster (RAC) databases
• C. in-place patching for patch bundles
• C. software required to configure nodes at startup
• D. out-of-place upgrades using the Oracle Universal Installer
• D. the GPnP software
• E. in-place patching for one-off patches
• E. a file system version used for the software to be installed
• F. in-place patching for patch sets
• F. a version of Automatic Storage Management (ASM) used for the cluster

Answer:

B,D,F