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

Answer Posted / aditi

commit save the transactions done after the last commit and rollback undo all transactions after last commit
Yes foreign key can have null value

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update values in a table in oracle?

783


How can I introduce multiple conditions in like operator?

762


How to assign data of the deleted row to variables?

833


What is coalesce function?

796


What is the max number of columns in an oracle table?

752


How to build data dictionary view an new database?

804


What is proxy method?

756


How to call a sub procedure?

842


What are the roles of dba?

825


Does oracle database need java?

766


What is blob datatype?

802


what is a Nested Loop join?

1826


How do you tell what your machine name is and what is its IP address?

1773


Explain about functional dependency and its relation with table design?

799


What is oracle open database communication (odbc)?

784