Which transaction sets properties like read-write access and isolation level?

Options
- ROLLBACK
- SET TRANSACTION
- TRUNCATE
- COMMIT

CORRECT ANSWER : SET TRANSACTION

Discussion Board
SET TRANSACTION

The SET TRANSACTION statement begins a read-only or read-write transaction, establishes an isolation level, or assigns the current transaction to a specified rollback segment. Read-only transactions are useful for running multiple queries against one or more tables while other users update the same tables.

Prajakta Pandit 02-21-2017 10:56 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
 
▲