Oracle Database 12c: RAC and Grid Infrastructure Administration Exam
Last exam update: Sep 01 ,2024
Page 1 out of 10. Viewing questions 1-15 out of 157
Question 1
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 2
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 3
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 4
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 5
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.
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%
None
Discussions
0/ 1000
Question 6
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.
Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
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.
Configure network time protocol (NT P) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
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.
Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.
C.
The sales database resource will be restarted automatically after an instance failure.
D.
If network time protocol (NT P) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
D.
The concurrency values are not shown because sales in not a RAC One Node database.
E.
If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle CTSSD Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
E.
The concurrency values are not shown because sales has only one of its four instances running.
Answer:
B,D
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 7
Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choose three.)
A.
You can create subdirectories under the USERS directory.
A.
The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
B.
You cannot rename a user-created subdirectory.
B.
The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
C.
You cannot drop a directory containing aliases unless you delete the aliases first.
C.
The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
D.
You cannot create a user-defined directory at the root (+) level.
D.
The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.
E.
You cannot create a nested subdirectory /USER1/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesnt exist.
E.
The CLUVFY utility can check the integrity of the OCR but not the OLR
Answer:
A, 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 8
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 12c for a standard cluster when using Full Featured Grid Naming Service (GNS).
A.
alter sequence seq1 cache 10000;
A.
You must create a Grid Management Repository database.
B.
alter sequence seq1 order;
B.
You must enable the Name Server Cache Daemon (NSCD).
C.
alter sequence seq1 noorder;
C.
A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
D.
exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’)
D.
Each cluster node must have at least two network interface cards,
E.
alter sequence seq1 keep;
E.
DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
F.
A DHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.
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 9
Which statement is true concerning the execution of the addNode.sh script for adding a node to an Oracle 12c Clusterware Standard Cluster that uses Grid Naming Service (GNS)?
A.
The Interconnects page shows the load contributed by database instances on the public network.
A.
Adding a node to a Standard Cluster requires the specification of the CLUSTER_NEW_NODE_ROLES parameter.
B.
The Interconnects page shows the load contributed by database instances on the private interconnect and the public network.
B.
Multiple nodes may be added to a standard cluster by a single execution of addNode.sh.
C.
The Interconnects page shows throughput contributed by individual sessions on the private interconnect.
C.
Nodes in a Standard Cluster must have a VIP specified when adding the node to a cluster.
D.
The Cluster Cache Coherency page shows which block classes are subject to intense global cache activity.
D.
Nodes in a Standard Cluster must have a High Availability IP (HAIP) adaptor specified when adding the node to a cluster.
E.
The Cluster Cache Coherency page shows which instances are responsible for intense global cache activity.
Answer:
A
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 10
Your four-node cluster runs Oracle 12c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 12c Release 1. All databases have one or more services defined. The Oracle 10g Release 2 database clients connect to the database instances using the public VIP. The Oracle 11g Release 2 and 12c Release 1 clients connect to the database instances using the Single Client Access Name (SCAN). You must change the public VIPS. Which three steps must be done to change the VIPs on host01, the first node in the cluster? (Choose three.)
A.
It is based on performance metrics provided by the database instances LREG processes.
A.
Use srvctl stop vip to stop the VIP on host01.
B.
LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.
B.
Use oifcfg setif to stop the VIP on host01.
C.
The services connection load balancing goal must be manually configured to enable server-side connect-time load balancing.
C.
Use srvctl start vip to start the VIP on host01.
D.
It’s enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.
D.
Use srvctl modify nodeapps to change the VIP on host01.
E.
Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN.
E.
Use oifcfg setif to start the VIP on host01.
Answer:
A C D
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 11
Which two types of IP addresses does Oracle Clusterware 12c acquire from DHCP when it started up on a cluster node using Grid Naming Service (GNS)? (Choose two.)
A.
The software must be installed into a cluster file system.
A.
Single Client Access Name (SCAN) virtual IP addresses (VIPs)
B.
The software must be installed into a local file system on each node.
B.
Grid Naming Service (GNS) VIPs
C.
RAC installations require Oracle Enterprise Edition.
C.
ASM Listener VIPs
D.
Fix-up scripts generated during the installation must be run as root on UNIX platforms.
D.
High Available IP (HAIP) addresses uses for the cluster interconnect
E.
The software can be installed into an ACFS file system.
E.
Intelligent Platform Management Interface (IPMI) IP addresses
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.
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%
G
50%
None
Discussions
0/ 1000
Question 12
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 12c? (Choose two.)
A.
To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.
A.
Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
B.
An ADVM volume is individually named and can contain only one file system.
B.
Configure network time protocol (NT P) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
C.
Only one ADVM volume can be created in an ASM disk group.
C.
Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.
D.
ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
D.
If network time protocol (NT P) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterwareis started.
E.
File systems contained in ADVM volumes may only contain database files.
E.
If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle CTSSD Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
Answer:
A,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 two statements are true concerning the installation of Oracle Grid Infrastructure 12c when using a Standard Cluster? (Choose two.)
A.
Single Client Access Name (SCAN) virtual IP addresses (VIPs)
A.
The Clusterware binaries may be installed without installing ASM binaries.
B.
Grid Naming Service (GNS) VIPs
B.
The Grid Infrastructure Management Repository is only required when using ASM.
C.
ASM Listener VIPs
C.
Specifying the use of Grid Naming Service is optional.
D.
High Available IP (HAIP) addresses uses for the cluster interconnect
D.
Normal Redundancy ASM Disk Groups used for Clusterware flies will contain three voting files regardless of the number of failgroups.
E.
Intelligent Platform Management Interface (IPMI) IP addresses
E.
High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
Answer:
A,D
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 14
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 12c?
A.
A policy-managed resource can be started manually using crsctl.
A.
Update the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.
B.
A policy-managed resource can be started manually using srvctl.
B.
Stage the patch on the cluster node where the OPatch utility will be executed.
C.
Resource dependencies are automatically set when using a policy-managed resource.
C.
Update the PATH environment variable on the node where will run the OPatch utility to point to the $ORACLE_HOME/OPatch directory.
D.
An administrator-managed resource can be started manually using crsctl.
D.
Stage the patch on the cluster nodes.
E.
An administrator-managed resource can be started manually using srvctl.
F.
The action script is automatically set when using a policy-managed resource.
Answer:
C
User Votes:
A
50%
A
50%
B
50%
B
50%
C
50%
C
50%
D
50%
D
50%
E
50%
F
50%
None
Discussions
0/ 1000
Question 15
Identify two reasons for the gc current block busy wait event. (Choose two.)
A.
Single Client Access Name (SCAN) virtual IP addresses (VIPs)
A.
A block is busy in the local cache.
B.
Grid Naming Service (GNS) VIPs
B.
A block is busy in the remote cache.
C.
ASM Listener VIPs
C.
The Cluster Interconnect is congested.
D.
High Available IP (HAIP) addresses uses for the cluster interconnect
D.
Either the local or remote CPUs have too large a run queue.
E.
Intelligent Platform Management Interface (IPMI) IP addresses