what is the difference between rollback & commit?
can a foreign key has null value?
Answer Posted / komal
Roll back Undoes whatever add, delete update transactions
we do.
Commit saves the add,delete update transactions
permanenetly in the database.
However a DML statement if fired in between a transaction
commits the complete list of add, delete update statements
above.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
definition of cluster and non-clustered index?
How to create a table interactively?
How do we represent comments in oracle?
What is where clause in oracle?
How to build data dictionary view an new database?
How to define default values for formal parameters?
How does oracle handle read consistency?
What is parameterized cursor in oracle?
What are the execution control statements?
What are the common oracle dba tasks?
What is raw datatype in oracle?
How remove data files before opening a database?
Explain compound trigger in oracle?
What is an oracle database table?