Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between rollback & commit?
can a foreign key has null value?
- 6 Answers
- 14686 Views
- I also Faced
- E-Mail Answers
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
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to display row numbers with the records?
Why packages are used in oracle?
What is a cursor variable?
How to create a new oracle data file?
Can you have more than one content canvas view attached with a window ?
How a database is related to tablespaces?
What is the data pump export utility?
what is the use of system.effective.date variable in oracle?
Explain enable novalidate constraint.
What is varray?
Why do you create or replace procedures rather that drop and recreate.
How many types of tables are there in oracle?
Give the constructs of a package, function or a procedure.
How to connect the oracle server as sysdba?
