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
- 14506 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 is a trigger and what are its types?
What is background process in Oracle?
Explain the different normalization forms?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is an oracle data file?
What are a query and state the different types of queries and their uses?
What is the relationship among database, tablespace and data file?
How do I learn what codesets are available in oracle?
How to create an initialization parameter file?
What types of joins are used in writing subqueries?
When do we use group by clause in a sql query?
Differentiate between post-database commit and post-form commit?
How to create a single index for multiple columns?
Will you be able to store pictures in the database?
What is difference between sid and service name in oracle?
