Oracle Database 12c: RAC and Grid Infrastructure Administration Exam
Last exam update: Sep 01 ,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.
Answer:
B D
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
None
Discussions
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
Answer:
A C
User Votes:
A
50%
B
50%
C
50%
D
50%
None
Discussions
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.
Answer:
A F
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
F
50%
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
Discussions
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
Answer:
A B E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
None
Discussions
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.
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%
None
Discussions
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.
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%
None
Discussions
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.
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%
None
Discussions
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
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%
None
Discussions
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.
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%
None
Discussions
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
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%
None
Discussions
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.
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%
None
Discussions
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
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%
None
Discussions
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.
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%
None
Discussions
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.
Answer:
A,C
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
None
Discussions
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.