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

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

what are the disadvantages of mysql? : Sql dba

0 Answers  

Can we call dml statement in function?

0 Answers  




what is explain plan?

4 Answers  

how to convert dates to character strings? : Sql dba

0 Answers  

What is difference between joins and union?

0 Answers  

What is difference between sql and oracle?

0 Answers  

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

What is Primary Key?

4 Answers   Ramco,

Do prepared statements prevent sql injection?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories