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
- 14443 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
Differentiate between function and procedure in oracle.
How view is different from a table?
What is a system tablespace?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Can you tell me how to add new column in existing views?how?How is possible?
Please explain oracle data types with examples?
What is enter substitution variable in oracle?
List the parts of a database trigger.
Differentiate between post-database commit and post-form commit?
What happens to indexes if you drop a table?
6. Display the client name and order date for all orders using the traditional method.
What is oracle rownum?
How to call a sub procedure?
How to retrieve the count of updated rows?
How to view the tablespaces in the current database?
