Create Next App

Exam contains 149 questions

Page 6 of 25

Question 31 🔥

Which two statements are true about database service administration in a RAC environment?

Which database solution meets these requirements?

A. When services are created with srvctl, tnsnames.ora is automatically updated.

Highly voted

B. When services are created with srvctl, the service is not started automatically.

Highly voted

C. Service attributes can be modified, unless an instance hosting the service is in restricted mode.

Highly voted

D. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automatically synchronized with the changes.

Highly voted

E. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR.

Highly voted

F. When services are started with srvctl, they are automatically added to the data dictionary of the hosting database if not already defined.

Highly voted

Discussion of the question

Question 32 🔥

Examine this command executed on the first node of a three-node cluster:# <GRID_INFRASTRUCTURE_ORACLE_HOME>/OPatch/opatchauto apply 18139660Which two tasks does this command perform?

Which database solution meets these requirements?

A. It applies a patch to the Grid Infrastructure only on the first cluster node.

Highly voted

B. It applies a patch to the Grid Infrastructure on all cluster nodes.

Highly voted

C. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, only on the first cluster node.

Highly voted

D. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, on all cluster nodes.

Highly voted

E. It applies a patch to all database ORACLE_HOMEs of any version on the first cluster node.

Highly voted

F. It applies a patch to all database ORACLE_HOMEs of any version on all cluster nodes.

Highly voted

Discussion of the question

Question 33 🔥

Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.Which two statements are true?

Which database solution meets these requirements?

A. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.

Highly voted

B. Clusterware will monitor the service while it is active.

Highly voted

C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.

Highly voted

D. When manually started, the service will always start on one or more available instances rather than on their preferred instances.

Highly voted

E. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.

Highly voted

Discussion of the question

Question 34 🔥

Which three statements are true about Oracle Enterprise Manager Topology Viewer?

Which database solution meets these requirements?

A. It displays which listeners listen on behalf of which instances.

Highly voted

B. It displays the relationship between targets of different target types in a cluster.

Highly voted

C. It displays the status of all cluster components.

Highly voted

D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).

Highly voted

E. It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM.

Highly voted

F. It displays the type of network used by RAC database instance.

Highly voted

Discussion of the question

Question 35 🔥

Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners?

Which database solution meets these requirements?

A. It is based on performance metrics provided by the database instances LREG processes.

Highly voted

B. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.

Highly voted

C. The service’s connection load balancing goal must be manually configured to enable server-side connect-time load balancing.

Highly voted

D. It’s enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.

Highly voted

E. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN.

Highly voted

Discussion of the question

Question 36 🔥

Which two statements are true regarding ASM Dynamic Volume manager (ADVM)?

Which database solution meets these requirements?

A. To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.

Highly voted

B. An ADVM volume is individually named and can contain only one file system.

Highly voted

C. Only one ADVM volume can be created in an ASM disk group.

Highly voted

D. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

Highly voted

E. File systems contained in ADVM volumes may only contain database files.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_068

Exam contains 149 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us