what is the difference between rollback & commit?
can a foreign key has null value?
Answer Posted / ashu_deepu
rollback is used to revert back the changes which we have made in the databases.when we do the rollback we return back to the last commit point which we have made.
commit is use to make the changes in the databases permanently. the values of the variables are written to the databases or disk.
FK can have null value but primary key can't have null value.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What happens if the update subquery returns multiple rows?
What is system tablespace?
How to define an anonymous procedure with variables?
What are the common oracle dba tasks?
What are oracle functions?
What is a read only transaction in oracle?
How to load data from external tables to regular tables?
What is java oracle used for?
Can we protect our pl/sql source code?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to write a query with a left outer join in oracle?
Explain the difference between a procedure and a function?
How to speed up webrick?
How can we view last record added to a table?
How to create a testing table in oracle?