1Z0_068 questions • Exam prepare

Exam contains 149 questions

Page 20 of 25

Question 115 🔥

Which two statements are true concerning Oracle Enterprise Manager Cloud Control Cluster Database performance pages? (Choose two.)

Which database solution meets these requirements?

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.

C. The Interconnects page shows throughput contributed by individual sessions on the private interconnect.

Highly voted

D. The Cluster Cache Coherency page shows which block classes are subject to intense global cache activity.

Highly voted

E. The Cluster Cache Coherency page shows which instances are responsible for intense global cache activity.

Discussion of the question

Question 116 🔥

Which three are benefits of using RAC databases with multiple instances? (Choose three.)

Which database solution meets these requirements?

A. surviving node failures

B. surviving storage network failures

Highly voted

C. surviving interconnect failures

Highly voted

D. automatic workload management for services on local connections

Highly voted

E. automatic workload management for services on Oracle Net connections

F. parallel execution across all instances supporting a balanced policy-management service

G. parallel execution across all instances supporting a singleton policy-management service

Discussion of the question

Question 117 🔥

Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)

Which database solution meets these requirements?

A. They are used when an application uses the DBMS_LOCK package for UL lock types.

B. They are used to coordinate the next value for a sequence created with the CACHE and ORDBR clauses.

C. They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses.

D. They are used to coordinate access across multiple library caches for the same stored procedure.

E. They are used to coordinate access across multiple library caches for anonymous PL/SQL execution.

Discussion of the question

Question 118 🔥

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

Which database solution meets these requirements?

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

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

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

D. Use Locally Managed Tablespaces with autoallocate.

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

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

Discussion of the question

Question 119 🔥

You administer a RAC database that currently runs on a four-node cluster but which has three instances.Which two statements are always true about redo logs for this RAC database? (Choose two.)

Which database solution meets these requirements?

A. A thread of redo must be created before starting a fourth instance if a thread is not already available.

B. A thread of redo must contain at least two log groups before it can be enabled.

C. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.

D. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

E. A thread of redo is automatically dropped when as instance is removed from a RAC database by using SRVCTL.

Discussion of the question

Question 120 🔥

Examine these commands:srvctl add service -db RACDB -service CRM -preferred RACDB_1 -available RACDB_2 - tafpolicy preconnect srvcl start service -db RACDB -service CRMInstances RACDB_1 and RACDB_2 run on host0l and host02, respectively.This is the only TNS entry in the client side tnsnames.ora:CRM =(DESCRIPTION =(FAILOVER=ON) (LOAD_BALANCE=ON)(ADDRESS= (PROTOCOL=TCP) (HOST=host0l-VIP.example.com)(PORT=1521))(ADDRESS= (PROTOCOL=TCP) (HOST=host02-VIP.example.com)(PORT=1521))(CONNECT_DATA = (SERVICE_NAME = CRM)(FAILOVER_MODE = (BACKUP=CRM_PRECONNECT)(TYPE=SESSION)(METHOD=PRECONNECT))))Which statement is true regarding the TAF settings?

Which database solution meets these requirements?

A. Clients using this configuration fail over and restart any active queries automatically.

B. Clients using this configuration fail over and restart any active transactions automatically.

C. This configuration will work only for a policy-managed RAC database.

D. The configuration is incomplete because the TNS entry for the preconnected backup session is missing.

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