Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Oracle 5
« Previous
Next »
Oracle provides _________transaction isolation levels.
Options
- One
- Two
- Three
- Four
CORRECT ANSWER : Three
Discussion Board
Isolation level
Oracle provides three transaction isolation levels. These transaction isolation levels are:
1. Read Committed: The read committed transaction isolation level is the Oracle default. With this setting, each query can see only data committed before the query, not the transaction, began.
2. Serializable: The serializable transaction isolation level is not supported with distributed transactions. With the serializable transaction isolation level, only data that was committed at the start of the transaction plus those made by the transaction itself through INSERTs, UPDATEs and DELETEs can be accessed by a query.
3. Read Only: With the Read Only transaction isolation level, only data that was committed at the start of the transaction can be accessed by a query. No modification to the data is allowed.
Prajakta Pandit 03-2-2017 12:35 AM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please 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
Oracle (40)
Oracle (30)
Oracle (49)
Oracle (51)
Oracle (52)
Oracle DBA (29)
Oracle PLSQL (30)
Oracle Replication (20)
Oracle Architecture (20)
Oracle Transaction (20)
PLSQL (22)
PLSQL (24)
PLSQL (50)
Advertisement
▲