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
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What are named parameters?
How does Oracle guarantee data integrity of data changes?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to best split csv strings in oracle 9i?
What is meant by an index?
How to define an anonymous procedure with variables?
What is a database schema in oracle?
what is the difference between data migration and production migration.
What is difference between sid and service name in oracle?
How to delete a user account in oracle?
How do I manually create a database in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What happens to the data files if a tablespace is dropped?
What is oracle server autotrace in oracle?