what is the difference between rollback & commit?
can a foreign key has null value?

Answer Posted / anjani kumar

Commits and Rollback both complete our transaction cycle.
we use commit to store the DML changes into DB but Rollback
performs undo to our DML transaction

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you identify oracle database software release?

727


How would you best determine why your MVIEW couldnt FAST REFRESH?

1609


What is instant client oracle?

760


How to resolve the ORA-39133 error in Oracle?

786


1) Does oracle have any table which contain all the exceptions and it's code internally?

1493


Why do we use coalesce function in oracle?

838


What are the system predefined user roles?

767


How to convert raw data type into text in oracle? Explain

776


Explain the use of ignore option in imp command.

753


Explain table?

841


What is raw datatype in oracle?

769


Why use resource manager in Oracle?

850


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

745


What is bulk load in oracle?

811


How to unlock the sample user account in oracle?

714