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
- 14495 Views
- I also Faced
- E-Mail Answers
Answer Posted / vaibhavi_dixit
With commit, all the changes, which are made using insert,
update or delete SQL statments, are save permanently in the
table(ie DB).Whereas, if one want to undo the changes made
by DML statments, then before issuing commit, one can use
rollback statment.Rollback statment has no effect, if used
after commit.
Yes foreign key can have null value.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
In which language oracle has been developed?
How to name query output columns in oracle?
What is query image?
What is meant by a deadlock situation?
What is sharded cluster?
How to connect to oracle using service name instead of sid?
How do I limit the number of oracle database connections generated by weblogic server?
Can you drop an index associated with a unique or primary key constraint?
Explain an index?
How to call a stored function in oracle?
Explain the use of online redo log files in oracle.
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Explain user account with reference to oracle.
What language does oracle use?
