What will happen after commit statement ?
- 2 Answers
- 7530 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
What will happen after commit statement ?..
Answer / highness
locks will be released
changes will be made permanent
| Is This Answer Correct ? | 3 Yes | 0 No |
What will happen after commit statement ?..
Answer / tulsi
The cursor having query as SELECT .... FOR UPDATE gets
closed after COMMIT/ROLLBACK.
The cursor having query as SELECT.... does not get closed
even after COMMIT/ROLLBACK
| Is This Answer Correct ? | 1 Yes | 0 No |
More SQL PLSQL Interview Questions
What do you mean by rowid?
Are dml statements autocommit?
What are the different type of joins in sql?
how to sort records in sql?
Which table is left in join?
How do you clear the screen in sql?
Does sap use sql?
Why trigger is used in sql?
Can we group by two columns in sql?
What is the use of <> sql?
What is %type in pl sql?
Is vs as in pl sql?
Categories
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
