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

Answer Posted / ven

Commit made changes permenant to the database.
Rollback made undo the changes.

Yes, FK has null values.

Is This Answer Correct ?    23 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define an external table with a text file?

783


what are the default admin accounts in Oracle 10g ?

734


What are the ways tablespaces can be managed and how do they differ?

1897


State and explain about oracle instance?

723


How to define an oracle cursor variable?

747






How to assign data of the deleted row to variables?

783


how can we store any pdf file in oracle

1829


Why does oracle 9i treat an empty string as null?

720


Describe the types of sub query?

729


What is the oracle implicit cursor?

770


how to handle exceptions in post production

1133


What is a view and how is it different from a table?

716


What is oracle open database communication (odbc)?

729


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2035


What is recovery manager in Oracle?

795