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
List out the types of joins.
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?
Which is faster join or subquery in oracle?
How to convert csv to table in oracle?
What is the simplest tool to run commands on oracle servers?
How to use group functions in the select clause using oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is max rowid in oracle?
What are nested tables?
How to define an oracle sub procedure?
What is object data modeling?
Compare and contrast between sql and sql server and explain its various functions?
Explain a private synonyms?
How to rename an existing table?
Can a parameter be passed to a cursor?