Exam 1z0-068 topic 1 question 109 discussion

Actual exam question from Oracle's 1z0-068

Question #: 109
Topic #: 1

Examine this tnsnames entry from a RAC configuration using a SCAN listener:
HR=(DESCRIPTION=
(LOAD_BALANCE =on)
(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(FORT=1521))
(CONNECT_DATA=(SERVICE_NAME=HRSRV)))
Which two statements are true about clients using this entry to connect? (Choose two.)

A. The host name in the tnsnames entry must be changed if nodes are added or removed from the Cluster.
B. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.
C. Client connection requests are automatically balanced across all IP addresses defined for the SCAN.
D. A client connection request is received by a SCAN listener that creates the connection to the least-loaded database instance.
E. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.

Show Suggested Answer

Suggested Answer: BD 🗳️

by torynek at April 28, 2021, 1:26 p.m.

Comments

Submit Cancel

Ygdng

2 months, 3 weeks ago

Selected Answer: CE

Answer: - Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available. When a client resolves the SCAN name it gets back all three SCAN VIPs. If the connection to the first VIP fails, the client transparently tries the next one, and so on, until one succeeds. Oracle Docs - Client connection requests are automatically balanced across all IP addresses defined for the SCAN. By default (and unless you’re using EZConnect), Oracle Net will round-robin or randomly pick among the three SCAN VIPs returned by DNS so that new connections are spread across them.

upvoted 1 times

...