Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Oracle Transaction
« Previous
Next »
Which of the following scenarios ends an Oracle transaction?
Options
- COMMIT or ROLLBACK is issued
- User disconnects from Oracle
- User process terminates abnormally
- All of the above
CORRECT ANSWER : All of the above
Discussion Board
Oracle Transaction
A transaction ends when any of the following actions occurs:
1. A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause.
- In a commit, a user explicitly or implicitly requested that the changes in the transaction be made permanent.
- Changes made by the transaction are permanent and visible to other users only after a transaction commits.
2. A user runs a DDL command such as CREATE, DROP, RENAME, or ALTER.
- The database issues an implicit COMMIT statement before and after every DDL statement.
- If the current transaction contains DML statements, then Oracle Database first commits the transaction and then runs and commits the DDL statement as a new, single-statement transaction.
3. A user exits normally from most Oracle Database utilities and tools, causing the current transaction to be implicitly committed. The commit behavior when a user disconnects its application-dependent and configurable.
4. A client process terminates abnormally, causing the transaction to be implicitly rolled back using metadata stored in the transaction table and the undo segment.
Prajakta Pandit 02-17-2017 04:27 AM
« Previous
Next »
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
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
▲