Latest Oracle 1z1-068 Actual Free Exam Questions & Community Discussion, Page 2

Question #12

Which three options have a RAC-specific tuning component?

A. the size of the online redo log buffers

B. sequence definitions

C. contention for archived redo log files

D. contention for online redo log files

E. contention on index leaf blocks

F. the load on the Cluster Interconnect

Discussion 0

Correct Answer: B,E,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #13

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 12c Clusterware?

A. Use the cluvfy comp command for the specific resource within a component.

B. Use the crsctl set log res "resource_name=debugging_level2" command.

C. Use the crsctl set trace res "resource_name=debugging_level" command.

D. Set the environment variable _USA_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #14

You plan to use DBCA to convert a single-instance Oracle 12c database on a local filesystem on a stand-alone server to RAC by using ASM.
You installed Grid Infrastructure 12c on a four-node cluster.
Examine this list of possible conversion steps:
1. Create a template and image les from the single-instance database by using DBCA.
2. Perform an RMAN backup of the single-instance database.
3. Validate the cluster using CLUVFY.
4. Copy the template and image les to a cluster node.
5. Restore the RMAN backup to the recovery area disk group on the cluster.
6. Perform an Oracle Database 12c RAC installation.
7. Create a RAC database with DBCA using the RMAN backup.
8. Create a RAC database with DBCA using the template.
Which statement correctly lists the minimum steps required to perform the conversion?

A. 2, 5, 6, 7

B. 1, 4, 8

C. 1, 4, 6, 8

D. 2, 3, 5, 7

E. 1, 3, 4, 6, 8

F. 2, 5, 7

Discussion 0

Correct Answer: D Vote an answer

Question #15

Which two are characteristics of any node that is part of a Grid Plug and Play (GPnP) Domain in Oracle Clusterware?

A. It has at least two nonroutable interfaces inside the GPnP domain for the private interconnect.

B. It has at least two routable interfaces outside the GPnP domain for the public interface.

C. It has a unique identifier that is unique inside the GPnP domain.

D. It has a unique identifier that is unique outside the GPnP domain.

E. It has at least one routable interface outside the GPnP domain for the public interface.

F. It has at least one routable interface inside the GPnP domain for the private interconnect.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #16

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

A. ocrcheck -local

B. ocrcheck -config -local

C. cluvfy comp ocr -n all -verbose

D. ocrcheck

E. ocrcheck -config

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #17

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

A. a Grid Management Cluster Health Management (CHM) application server

B. a Grid Management Repository database

C. a network interface for the public network

D. a network interface for private interconnect only

E. a network interface for ASM and private interconnect traffic

Discussion 0

Correct Answer: B,D Vote an answer

Question #18

Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster? (Choose two.)

A. at least two for the public network

B. at least two for the interconnect

C. at least one for the public network

D. at least one for the storage network

E. at least one for the interconnect

F. at least two for the storage network

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #19

Which two statements are tuning recommendations for RAC database? (Choose two.)

A. Use sequences with CACHE and NOORDER, if possible.

B. Use Locally Managed Tablespaces with large uniform extent sizes.

C. Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query.

D. Use Locally Managed Tablespaces with autoallocate.

E. Use sequences with CACHE and ORDER, if possible.

F. Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing.

Discussion 0

Correct Answer: A,D Vote an answer

Question #20

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.
Examine these commands executed on HOST01:
$ srvctl add service -db CDB1 -pdb PDB_1 service AR -serverpool prod_pool -cardinality singleton
$ srvctl start service -db CDB1 -service AR
Which two statements are true regarding the AR service?

A. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.

B. AR is available only on the CDB1 instance on HOST01.

C. AR can fail over to any one of the available CDB1 instances.

D. AR can fail over to any other available CDB1 instance in prod_pool.

E. AR is available on any one available CDB1 instance in prod_pool at any one time.

Discussion 0

Correct Answer: D,E Vote an answer

Question #21

Which three statements are true about Oracle Clusterware components, architecture, and behavior?

A. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down.

B. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time.

C. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node.

D. The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availability of cluster resources defined in the Oracle Local Repository file (OLR).

E. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing the Oracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started.

F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).

Discussion 0

Correct Answer: A,C,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #22

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

A. The Installer permits the creation of a disk group for use by the voting disks and OCR file.

B. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

C. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

D. ASM disk groups used for voting files and OCR files require a quorum failgroup.

E. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

Discussion 0

Correct Answer: B,D Vote an answer

Oracle 1z1-068 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z1-068 Demo