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
- 14692 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
What privilege is needed for a user to create tables in oracle?
Explain about functional dependency and its relation with table design?
What is partitioned table in Oracle?
What is the difference between hot backup and cold backup in oracle?
What is a nested table and how is it different from a normal table?
How do I find the database name in oracle?
What are the most common interview questions on ETL Testing for experience?
How to rename a tablespace in oracle?
Explain an integrity constrains?
Explain a data segment?
Explain the use of parfile option in exp command.
How to apply filtering criteria at group level in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain integrity constraints?
How to bring a tablespace offline?
