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

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


Please Help Members By Posting Answers For Below Questions

What are internal user account in oracle?

758


How to define and use table alias names in oracle?

721


List out the difference between commit, rollback, and savepoint?

809


can u plz provide me oca sql dumps please i need them

1702


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2100


How many types of synonyms in Oracle?

830


How to create a stored function in oracle?

837


Difference between oracle's plus (+) notation and ansi join notation?

850


Explain the use of control file?

876


What is the oracle implicit cursor?

798


How to define a procedure inside another procedure?

760


Give the various rollback segment states.

814


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5056


Explain an integrity constrains?

895


What is the difference between online and offline backups?

752