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
Is insert autocommit in oracle?
How to do a full database export?
What is a connect identifier?
What are the different types of database objects?
How to define a data field as not null?
Why cursor variables are easier to use than cursors?
Explain enable novalidate constraint.
What is a trigger oracle?
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.
Can objects of the same schema reside in different tablespace?
Give the various exception types.
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is a proxy object?
Explain the use of rows option in exp command.
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.