what is the difference between rollback & commit?
can a foreign key has null value?

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


Please Help Members By Posting Answers For Below Questions

Is insert autocommit in oracle?

779


How to do a full database export?

840


What is a connect identifier?

740


What are the different types of database objects?

722


How to define a data field as not null?

835


Why cursor variables are easier to use than cursors?

765


Explain enable novalidate constraint.

790


What is a trigger oracle?

793


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1980


Can objects of the same schema reside in different tablespace?

775


Give the various exception types.

733


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4178


What is a proxy object?

765


Explain the use of rows option in exp command.

797


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

786