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
- 14690 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
How to use "while" statements in oracle?
What are the different pseudo commands? Explain in general?
Hi Can any one tell me what are the API's used in requisition import.
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??
What is the minimum client footprint required to connect c# to an oracle database?
Where do we use decode and case statements?
What is a sub query? Describe its types?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What are the uses of a database trigger?
Explain an exception?
Explain the use of parfile option in exp command.
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Explain about the analyze command in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to connect to oracle using service name instead of sid?
