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
- 14499 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
Why use resource manager in Oracle?
What is an Oracle Instance?
How to start your 10g xe server?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Difference between varchar and varchar2 data types?
How to display row numbers with the records?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
Why do we need integrity constraints in a database?
How do I know if oracle is installed on windows?
What is translate in oracle?
What are the uses of synonyms?
How to set up autotrace for a user account?
How to use "in" parameter properly?
What is an oracle database?
What is flashback in Oracle?
