What does COMMIT do ?

Answer Posted / kiran

when ever a user performs commit action , the data is
permanently written the the tablespace and cannot be rolled
back

after performing the commit operation , the users in other
user sessions can view only the committed data

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Point the difference between translate and replace?

857


Explain the use of indexes option in imp command.

829


How to turn on or off recycle bin for the session?

845


What is tns entry?

830


What is the difference between hot backup and cold backup in oracle?

782


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2411


What is a Garbage Collection? and what is full recursive Garbage collection?

2645


What is logical backup in oracle?

809


What are the oracle built-in data types?

787


Please explain oracle data types with examples?

826


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

789


Difference between inner join vs where ?

814


Explain the use of grant option in exp command.

798


How to create a table index in oracle?

877


What are the different types of trigger and explain its various uses and functions?

767