oracle 1z0-068 practice test

Oracle Database 12c: RAC and Grid Infrastructure Administration Exam

Last exam update: Nov 17 ,2024
Page 1 out of 11. Viewing questions 1-15 out of 157

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.
Mark Question:
Answer:

B D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

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
Mark Question:
Answer:

A C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

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.
Mark Question:
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

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
Discussions
vote your answer:
A
B
C
D
E
F
0 / 1000

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
Mark Question:
Answer:

A B E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

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.
Mark Question:
Answer:

D,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

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.
Mark Question:
Answer:

D,E,F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
0 / 1000

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.
Mark Question:
Answer:

C,E,F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

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
Mark Question:
Answer:

B,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
G
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
G
0 / 1000

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.
Mark Question:
Answer:

B,C,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

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
Mark Question:
Answer:

B,D,F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
F
0 / 1000

Question 11

You are installing Oracle Grid Infrastructure 12c and configuring a Flex Cluster?
Which two elements are required to support this configuration? (Choose two.)

  • A. The hub node is evicted from the cluster
  • A. a Grid Management Repository database
  • B. Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without service disruption.
  • B. a network interface for ASM and private interconnect traffic
  • C. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving hub nodes.
  • C. a network interface for private interconnect only
  • D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving leaf nodes.
  • D. a network interface for the public network
  • E. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes.
  • E. a Grid Management Cluster Health Management (CHM) application server
  • F. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes.
  • G. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leaf nodes, or both.
Mark Question:
Answer:

A,C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
G
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
G
0 / 1000

Question 12

Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLR
files? (Choose three.)

  • A. It is automatically created when a service is created using SRVCTL ADD SERVICE.
  • A. ocrcheck
  • B. It contains a list of server pools on which the instances hosting the service can run.
  • B. ocrcheck -config -local
  • C. It contains a node list and instance-to-node mapping information for the service.
  • C. ocrcheck -local
  • D. It specifies the instance to which the service should fail over, if the preferred instance shuts down or fails.
  • D. ocrcheck -config
  • E. It is automatically created when a service is created using DBMS_SERVICE.CREATE_SERVICE.
  • E. cluvfy comp ocr -n all -verbose
Mark Question:
Answer:

A,B,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
0 / 1000

Question 13

Which three are characteristics of leaf nodes in an Oracle Clusterware 12c Flex Cluster? (Choose
three.)

  • A. CRM is only available for new logins on the CDB1 instance on host01.
  • A. They can be on a different subnet to the hub nodes.
  • B. CRM is available for new logins on one CDB1 instance.
  • B. Grid Naming Service (GNS) must exist on one of the leaf nodes.
  • C. The srvctl start service command automatically opens PDB_1 if not already opened.
  • C. They discover hub nodes automatically at startup.
  • D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.
  • D. They require direct access to shared storage.
  • E. The CRM service is not available for new logins on any instance of CDB1.
  • E. They may discover hub nodes without having the DNS delegation configured by network administrators.
  • F. Oracle database 12c RAC instances may not run on leaf nodes.
Mark Question:
Answer:

C,E,F

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
0 / 1000

Question 14

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. Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high- availability resource.
  • A. crsctl stop crs
  • B. All servers in a new cluster installation belong to the generic server pool.
  • B. crsctl stop cluster
  • C. The server pool contains servers that host administrator-defined high availability resources.
  • C. crsctl disable crs
  • D. Server pools must be managed with the srvctl utility for servers hosting a database.
  • D. crsctl config crs
  • E. All servers in a new cluster installation belong to the free server pool.
Mark Question:
Answer:

A,C

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
0 / 1000

Question 15

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. The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.
  • A. Pluggable Databases (PDBs)
  • B. The LMD0 runs only on the instance that masters all GES resources.
  • B. administrator-defined resources
  • C. When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.
  • C. local resources
  • D. The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
  • D. database transactions
  • E. The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.
  • E. cluster resources
  • F. An LMD0 process runs on all instances.
  • G. The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
Mark Question:
Answer:

A,B,E

User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
E
50%
F
50%
G
50%
Discussions
vote your answer:
A
A
B
B
C
C
D
D
E
E
F
G
0 / 1000
To page 2