exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 3 discussion

Actual exam question from Oracle's 1z0-082
Question #: 3
Topic #: 1
[All 1z0-082 Questions]

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

  • A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
  • B. Source Routing requires the use of a name server
  • C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
  • D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
  • E. Load Balancing requires the use of a name server
  • F. Connect Time Failover requires the connect string to have two or more listener addresses configured
Show Suggested Answer Hide Answer
Suggested Answer: CDF 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Rivaldo11
Highly Voted 4 years, 6 months ago
I think C, D and F are correct.
upvoted 13 times
ama
4 years, 6 months ago
D seems a legit answer.. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9
upvoted 3 times
...
...
aihamza
Most Recent 6 months ago
C, D and F are correct answers.
upvoted 1 times
...
dinati7315
6 months, 3 weeks ago
A. Connect Time Failover requires the use of Transparent Application Failover (TAF): Connect Time Failover allows Oracle Net to automatically fail over to another Oracle Database instance if the initial connection attempt fails. TAF enhances this feature by preserving the client-side session state during a failover. D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration: Load Balancing in Oracle Net distributes connection requests across multiple dispatchers to optimize resource utilization in a Shared Server (or MTS) configuration. F. Connect Time Failover requires the connect string to have two or more listener addresses configured: Connect Time Failover requires multiple listener addresses specified in the connect string to provide failover capability. If one listener is unavailable, Oracle Net attempts to connect to the next listener in the list. https://bitly.cx/ExamsTopics
upvoted 1 times
...
auwia
1 year, 7 months ago
Selected Answer: CDF
A. Connect Time Failover requires the use of Transparent Application Failover (TAF) --> False B. Source Routing requires the use of a name server --> False, IP address are also accepted. C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall --> True D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration --> True E. Load Balancing requires the use of a name server --> False, IP address are also accepted. F. Connect Time Failover requires the connect string to have two or more listener addresses configured. --> True
upvoted 2 times
...
Ashikraja
1 year, 11 months ago
BCF is right
upvoted 1 times
...
yarsalan
3 years ago
D is incorrect. Standalone Oracle databases perform load balancing by distributing connections among the shared server dispatcher processes. Check out https://docs.oracle.com/en/database/oracle/oracle-database/19/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9
upvoted 2 times
...
Kira_Sat
3 years ago
Selected Answer: CDF
Correct Answer : C,D and F
upvoted 3 times
...
adozoo
3 years, 1 month ago
CDF is right!!!
upvoted 1 times
...
elvegaa
4 years, 2 months ago
C, D & F
upvoted 3 times
...
you1234
4 years, 6 months ago
ama, Please suggest suitable answer
upvoted 2 times
ama
4 years, 6 months ago
C, D, F
upvoted 6 times
...
...
you1234
4 years, 7 months ago
A & C & F is correct answer
upvoted 2 times
elvegaa
4 years, 2 months ago
A is wrong. Connect-Time Failover involves not yet connected sessions to failover a different address in case the first attempt is unreacheble. Transparent Application Failover involves sessions already connected in the database, to failover to the next address when the session is terminated. Pretty similar, but not dependent. You can have a configuration with ConnectTime Failover but not Transparent Application Failover
upvoted 2 times
...
ama
4 years, 6 months ago
A is wrong… Connect-Time Failover is a feature of local naming method, and can be easily set up by adding a tns entry into tnsnames. ora file on the client machine, then the client can connect to the second database (listener) if the first database (listener) cannot be connected
upvoted 6 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago