commit save the transactions done after the last commit and rollback undo a

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

Question Posted / aditi

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

Please Help Members By Posting Answers For Below Questions

What are the limitations of check constraint?

963

What is system tablespace?

1042

Explain the use of record option in exp command.

946

Is there an oracle sql query that aggregates multiple rows into one row?

931

What happens if variable names collide with table/column names?

1101

what are the advantages of running a database in archive log mode?

2142

How to store pictures on to the database?

923

What are the roles of dba?

1018

How would you best determine why your MVIEW couldnt FAST REFRESH?

1835

How to convert character types to numeric types?

1054

Explain temporal data types in oracle

1040

How to use "while" statements in oracle?

1229

What is logical backup in oracle?

967

What is the difference between formal parameters and actual parameters?

1002

What is a procedure in oracle?

1073