ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-068 All Questions

View all questions & answers for the 1z0-068 exam
Go to Exam

Exam 1z0-068 topic 1 question 47 discussion

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

Which three statements are true about services when used with transparent application failover (TAF) for an administrator-managed RAC database?

  • A. TAF-enabled sessions fail over to a surviving instance accepting logins for the service.
  • B. TAF-settings for the service override TAF settings in TNS entry used by the client.
  • C. TAF can restart a query or a transaction after failover.
  • D. The TAF settings for a client connections overrides any TAF settings in the service definition.
  • E. TAF PRECONNECT requires configuration for the service and in the client TNS entry.
Show Suggested Answer Hide Answer
Suggested Answer: ABC 🗳️
A: SESSION failover. When the connection to an instance is lost, SESSION failover results only in the establishment of a new connection to another Oracle RAC node; any work in progress is lost. SESSION failover is ideal for online transaction processing (OLTP) systems, where transactions are small.
C: SELECT failover. With SELECT failover, Oracle Net keeps track of all SELECT statements issued during the transaction, tracking how many rows have been fetched back to the client for each cursor associated with a SELECT statement. If the connection to the instance is lost, Oracle Net establishes a connection to another Oracle RAC node and re-executes the SELECT statements, repositioning the cursors so the client can continue fetching rows as if nothing has happened.
The SELECT failover approach is best for data warehouse systems that perform complex and time-consuming transactions.
D: Oracle's answer to application failover is a new Oracle Net mechanism dubbed Transparent Application Failover. TAF allows the DBA to configure the type and method of failover for each Oracle Net client.
Incorrect Answers:
E: In PRECONNECT failover, the application simultaneously connects to both a primary and a backup node. This offers faster failover, because a pre-spawned connection is ready to use. But the extra connection adds everyday overhead by duplicating connections.
References:
http://www.dba-oracle.com/art_oramag_rac_taf.htm
by JL0123456789 at April 12, 2022, 11:27 a.m.

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
Submit Cancel
rodriguesJC
5 months ago
ABD, C and E are false.
upvoted 1 times
...
bestsalman
5 months, 1 week ago
ABE is correct answer for me , c is not for update,insert,create only select will continue with TAF
upvoted 1 times
...
JL0123456789
9 months, 3 weeks ago
C) IS NOT CORRECT , TAF can restart a query after failover has completed but for other types of transactions, such as INSERT, UPDATE, or DELETE, the application must rollback the failed transaction and resubmit the transaction. https://docs.oracle.com/database/121/RACAD/GUID-DEF850F6-27E9-428E-B8FC-530230D78AD2.htm#RACAD8268
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago