Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between rollback & commit?
can a foreign key has null value?
- 6 Answers
- 14241 Views
- I also Faced
- E-Mail Answers
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 do you tell what your machine name is and what is its IP address?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What do you mean by merge in oracle and how can you merge two tables?
How to experiment a data lock in oracle?
How would you go about verifying the network name that the local_listener is currently using?
is there a tool to trace queries, like profiler for sql server?
Which are the five query types available in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is a relational database management system?
What are data pump export and import modes?
What is a static data dictionary in oracle?
How to delete multiple rows from a table in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is an oracle cursor variable?
How to synchronize 2 schema's objects?
