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
- 14467 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 assign a tablespace to a users in oracle?
What is SQL Tuning Advisor in Oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is meant by joins? List out the types of joins.
What is oracle data type?
How to create an oracle testing table?
how to do daily transactions with out sql* loader control file regesterd in apps?
How do I manually create a database in oracle?
Briefly explain what is literal? Give an example where it can be used?
What is a database table in oracle?
What is different types of joins?
What are the differences between lov and list item?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How can we create the complete backup of data in the oracle.
State and explain about oracle instance?
