what is commit? : Sql dba



what is commit? : Sql dba..

Answer / Shubhi Pathak

A "commit" in SQL context, especially for Oracle Database (PLSQL), is a database transaction control statement. It saves all the changes made during a transaction permanently to the database. Committing a transaction makes those changes available to other sessions and marks the current transaction as complete.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1 Answers  


what is bcp? When does it used? : Sql dba

0 Answers  


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

7 Answers   iGate,


How do I edit a trigger in sql developer?

1 Answers  


What does truncate mean in sql?

1 Answers  


When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,


what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1 Answers  


What is the function that is used to transfer a pl/sql table log to a database table?

1 Answers  


What is meant by cursor in sql?

1 Answers  


What is sqlca in powerbuilder?

1 Answers  


What is primary key and foreign key?

1 Answers  


What are the methods of filing?

1 Answers  


Categories