DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

Best Oracle 1Z0-068 Practice Exams and Real Exam Simulations, Oracle Database 12c RAC Exam | SPOTO

Welcome to SPOTO's Best Oracle 1Z0-068 Practice Exams and Real Exam Simulations page, your ultimate resource for mastering the Oracle Database 12c RAC Exam. Our platform offers a comprehensive array of resources, including practice tests, free tests, online exam questions, sample questions, exam dumps, exam questions and answers, mock exams, and exam materials. Tailored specifically for the 1Z0-068 exam, our practice exams and real exam simulations cover essential topics necessary for success. Whether you need to brush up on RAC architecture, cluster installation and configuration, or troubleshooting and tuning, our resources have you covered. With our latest practice tests, you can confidently prepare to pass the certification exam and advance your career in Oracle Database administration. Trust SPOTO to provide you with the best tools needed for exam success!
Take other online exams
Question #1
Which two actions guarantee that time is synchronized properly on all nodes in a cluster afterinstalling Oracle Grid Infrastructure 12c? (Choose two.)
A. To create an ADVM volume, disk group attributes COMAPTIBLE
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
View answer
Correct Answer: AE

View The Updated 1Z0-068 Exam Questions

SPOTO Provides 100% Real 1Z0-068 Exam Questions for You to Pass Your 1Z0-068 Exam!

Get 1Z0-068 Practice Test
Question #2
For which three entities can the what-if command evaluation be used to determine the impact ofclusterware 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
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
View answer
Correct Answer: ABE
Question #3
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
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
View answer
Correct Answer: BD
Question #4
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 clusterA
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
View answer
Correct Answer: AC
Question #5
Your four-node cluster runs Oracle 12c Clusterware and supports a mix of RAC databases from Oracle10g 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 SingleClient Access Name (SCAN).You must change the public VIPS.Which three steps must be done to change the VIPs on host01, the first n
A. It is based on performance metrics provided by the database instances LREG processes
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
View answer
Correct Answer: ACD
Question #6
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it fromstarting 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
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
View answer
Correct Answer: AC
Question #7
Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLRfiles? (Choose three.)
A. It is automatically created when a service is created using SRVCTL ADD SERVICE
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
E. cluvfy comp ocr -n all -verbose
View answer
Correct Answer: ABE
Question #8
Which two types of IP addresses does Oracle Clusterware 12c acquire from DHCP when it started upon a cluster node using Grid Naming Service (GNS)? (Choose two.)
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
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
View answer
Correct Answer: DE
Question #9
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 12c for astandard cluster when using Full Featured Grid Naming Service (GNS).
A. alter sequence seq1 cache 10000;A
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
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
View answer
Correct Answer: CEF
Question #10
Which two statements are true concerning the installation of Oracle Grid Infrastructure 12c whenusing a Standard Cluster? (Choose two.)
A. Single Client Access Name (SCAN) virtual IP addresses (VIPs)A
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
View answer
Correct Answer: AD
Question #11
Which three are characteristics of leaf nodes in an Oracle Clusterware 12c Flex Cluster? (Choosethree.)
A. CRM is only available for new logins on the CDB1 instance on host01
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
View answer
Correct Answer: CEF
Question #12
Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choosethree.)
A. You can create subdirectories under the USERS directory
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
View answer
Correct Answer: ACE
Question #13
Identify two reasons for the gc current block busy wait event. (Choose two.)
A. Single Client Access Name (SCAN) virtual IP addresses (VIPs)A
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
View answer
Correct Answer: AB
Question #14
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure12c?
A. A policy-managed resource can be started manually using crsctl
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
View answer
Correct Answer: C
Question #15
Which statement is true concerning the execution of the addNode.sh script for adding a node to anOracle 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
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
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
View answer
Correct Answer: A

View The Updated Oracle Exam Questions

SPOTO Provides 100% Real Oracle Exam Questions for You to Pass Your Oracle Exam!

Get Oracle Practice Test

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.