exam questions

Exam 1z0-078 All Questions

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

Exam 1z0-078 topic 1 question 54 discussion

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

Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

  • A. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
  • B. When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.
  • C. When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.
  • D. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
Tunglinfo9
3 months ago
Selected Answer: A
In summary, the colocation_tag attribute is used to provide a hint to the listener to route clients with the same tag to the same instance in an Oracle RAC environment. This is done to improve data locality and reduce inter-instance communication by grouping clients that are likely to access the same data.
upvoted 1 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