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
- 14282 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
What do you mean by a database transaction & what all tcl statements are available in oracle?
What are the types of trigger in oracle?
What is the dynamic sql in oracle?
How to select some columns from a table in oracle?
How many categories of data types?
What is oracle analytical function?
What is the difference between a user and a schema in oracle?
How to revoke create session privilege from a user in oracle?
What is blob datatype?
How to import one table back from a dump file?
State some uses of redo log files?
Explain the use of online redo log files in oracle.
What is the difference between sharding and partitioning?
Can we save images in a database and if yes, how?
How to create a server parameter file?
