What will happen after commit statement ?

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

Post New Answer

More SQL PLSQL Interview Questions

What is trigger in sql? Explain

0 Answers  


Is sqlite free?

0 Answers  


What is dml with example?

0 Answers  


What is difference between inner join and cross join?

0 Answers  


How do I start sql profiler?

0 Answers  






Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,


explain mysql aggregate functions. : Sql dba

0 Answers  


full outer join syntax

5 Answers  


What is a recursive stored procedure?

0 Answers  


what is the main difference between join and subqurey?

3 Answers   Oracle,


What is the difference between a database and a relational database?

0 Answers  


What is the purpose of primary key?

0 Answers  


Categories