1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What will happen after commit statement ?

Question Posted / guest

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 rule base and cost base optimizer?

2 Answers   Thermotech,

What is schema in sql?

0 Answers  

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

What version is sql?

0 Answers  

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,




how to concatenate two character strings? : Sql dba

0 Answers  

How do you clear the screen in sql?

0 Answers  

How can you know that statistics should be updated?

0 Answers  

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

What is indexes?

0 Answers  

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

How do I filter in sql profiler?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories