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

List out the types of joins.

866


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1730


Which is faster join or subquery in oracle?

749


How to convert csv to table in oracle?

753


What is the simplest tool to run commands on oracle servers?

759


How to use group functions in the select clause using oracle?

840


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

813


What is max rowid in oracle?

798


What are nested tables?

882


How to define an oracle sub procedure?

817


What is object data modeling?

728


Compare and contrast between sql and sql server and explain its various functions?

762


Explain a private synonyms?

843


How to rename an existing table?

808


Can a parameter be passed to a cursor?

835