Create Next App

Exam contains 94 questions

Page 3 of 16

Question 13 🔥

Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)

Which database solution meets these requirements?

A. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.

Highly voted

B. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.

Highly voted

C. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.

Highly voted

D. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.

Highly voted

E. Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.

Highly voted

Discussion of the question

Question 14 🔥

Disk group DGRP1 has these attributes:1. Normal redundancy2. Two failure groups FG1 and FG2 with two disks each3. Compatibility settings set to 19.0The FG1 failure group goes offline due to hardware failure.Which two statements are true? (Choose two.)

Which database solution meets these requirements?

A. New allocation units are mirrored in the FG2 failure group until FG1 is restored and the disk group resynchronized.

Highly voted

B. The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized.

Highly voted

C. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

Highly voted

D. Transactions on database objects stored in tablespaces in the DGRP1 disk group fail.

Highly voted

Discussion of the question

Question 15 🔥

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.

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 16 🔥

Which two steps must always be performed to delete node host04 from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)

Which database solution meets these requirements?

A. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.

Highly voted

B. Run the crsctl delete node -n host04 command as root on host04.

Highly voted

C. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.

Highly voted

D. Run the crsct1 unpin css - host04 command as root on host04.

Highly voted

E. Run the rootcrs.pl -deconfig -force command as root on host04.

Highly voted

F. Run the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.

Highly voted

Discussion of the question

Question 17 🔥

Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)

Which database solution meets these requirements?

A. Services support the balancing of client connections across RAC database instances.

Highly voted

B. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.

Highly voted

C. Load balancing can be done by the client or the listener, but not both, for any one connection request.

Highly voted

D. Client-side connect-time load balancing can balance connection requests across SCAN listeners.

Highly voted

E. Load balancing can be done by the client, the listener, or both, for any one connection request.

Highly voted

Discussion of the question

Question 18 🔥

Examine this sequence of commands:The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)

Which database solution meets these requirements?

F. The Oracle Clusterware stack is started on all nodes.

Highly voted

A. The Oracle Clusterware stack is stopped on all nodes.

Highly voted

B. The Oracle Clusterware stack is prevented from being automatically started on HOST01.

Highly voted

C. The Oracle Clusterware stack is prevented from being automatically started on all nodes.

Highly voted

D. The Oracle Clusterware stack is stopped on all nodes except HOST01.

Highly voted

E. The Oracle Clusterware stack is started on all nodes except HOST01.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_078

Exam contains 94 questions

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

Company

Product

Resources

Follow us