what is the difference between rollback & commit?
can a foreign key has null value?
- 6 Answers
- 13276 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashu_deepu
rollback is used to revert back the changes which we have made in the databases.when we do the rollback we return back to the last commit point which we have made.
commit is use to make the changes in the databases permanently. the values of the variables are written to the databases or disk.
FK can have null value but primary key can't have null value.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the differences between interval year to month and interval day to second?
What is the meaning of recursive hints in oracle?
How to display employee records who gets more salary than the average salary in the department?
what is difference between sql plus and sql*plus? (not sql and sql plus).
State and explain about oracle instance?
What is oracle in java?
What is a procedure in oracle?
what is the scripts in data base?
What is flashback in Oracle?
How do I call oracle stored procedures that take no parameters?
What is data block in Oracle?
How will you differentiate between varchar & varchar2?
Can objects of the same schema reside in different tablespace?
How to define an anonymous procedure with variables?
What are a cluster and non-cluster index?
