How do we name a transaction?

Options
- SET TRANSACTION ... NAME
- TRANSACTION ... NAME
- TRANSACTION ... NAME =
- SET TRANSACTION = NAME

CORRECT ANSWER : SET TRANSACTION ... NAME

Discussion Board
SET TRANSACTION ... NAME

In Oracle, the SET TRANSACTION statement is used to set a transaction as READ ONLY, set a transaction as READ WRITE, set a transaction's ISOLATION LEVEL, assign a NAME to a transaction, or assign a ROLLBACK SEGMENT to a transaction.

Syntax:

SET TRANSACTION [ READ ONLY | READ WRITE ]
[ ISOLATION LEVEL [ SERIALIZE | READ COMMITED ]
[ USE ROLLBACK SEGMENT 'segment_name' ]
[ NAME 'transaction_name' ];

where,

READ ONLY is optional. If specified, it sets the transaction as a read-only transaction.
READ WRITE is optional. If specified, it sets the transaction as a read/write transaction.
ISOLATION LEVEL is optional. If specified, it has two options:
1. ISOLATION LEVEL SERIALIZE : If a transaction attempts to update a resource that has been updated by another transaction and uncommitted, the transaction will fail.

2. ISOLATION LEVEL READ COMMITTED : If a transaction requires row locks held by another transaction, the transaction will wait until the row locks are released.

ROLLBACK SEGMENT is optional. If specified, it assigns the transaction to a rollback segment identified by 'segment_name' which is the segment name enclosed in quotes.

Prajakta Pandit 02-19-2017 11:29 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲