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
- 14445 Views
- I also Faced
- E-Mail Answers
Answer Posted / anjani kumar
Commits and Rollback both complete our transaction cycle.
we use commit to store the DML changes into DB but Rollback
performs undo to our DML transaction
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the various types of snapshots ?
What is sequence?
What are the ways tablespaces can be managed and how do they differ?
what are the advantages of running a database in archive log mode?
How do we get field detail of a table?
State the various uses of dbcc command?
How to create lov dynamically at runtime & attach to text field?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to use subqueries with the exists operator in oracle?
What is a connect identifier?
what happened to the global index when I truncate the data in one of the partition?
What is format trigger?
What is oracle host variable?
How to write an inner join with the where clause in oracle?
What happens in oracle commit?
