Which parameter is used to enable transactions to complete after failover of the primary server?

1. A. HA_FOC_ORDER
2. B. FAILOVER_CALLBACK
3. C. CLUSTER_TXN_SCOPE
4. D. FAILOVER_TX_TIMEOUT

Correct Answer: D

Which statement is true regarding default roles?

1. A. The DBSA can define a default role to assign only to the PUBLIC group for a particular database.
2. B. The privileges associated with a default role takes precedence over the privileges granted to an individual user.
3. C. The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.
4. D. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

Correct Answer: C

How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

1. A. Use the 'Committed Read' isolation level.
2. B. Use the RETAIN UPDATE LOCKS clause with isolation level.
3. C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.
4. D. Use the SET TRANSACTION command to with SERIALIZABLE clause.

Correct Answer: B