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
- 14286 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
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain oracle insert into command?
Does oracle partitioning improve performance?
What is background process in Oracle?
How to define an oracle cursor variable?
What is private procedure oracle?
What are the different types of partitions in oracle?
What is index-organized table in Oracle?
What are privileges and grants?
What is integrity and what is constraint??Explain with example
How to rename a column in an existing table?
What are joins, explain all types of joins?
What is oracle rownum?
What are the differences between lov and list item?
What are group functions in oracle?
