Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers  


Is sql a microsoft product?

0 Answers  


Is inner join faster than left join?

0 Answers  


How do I turn a list into a table?

0 Answers  


What is a call statement? Explain with an example.

0 Answers  






Is left join same as join?

0 Answers  


Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,


What is 19 null in sql?

0 Answers  


What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,


What is database white box testing and black box testing?

0 Answers  


What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,


What is a unique key and primary key and foreign key?

0 Answers  






Categories