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 are group functions in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How many file formats are supported to export data?
What is an oracle cursor variable?
How index is implemented in oracle database?
Explain the difference between a procedure and a function? What do you understand by those terms?
Which is better Oracle or MS SQL? Why?
What are the built-in functions used for sending Parameters to forms ?
What is BBED in Oracle?
What are the different editions of oracle?
When do you get a .pll extension in oracle?
What is ordinary table in oracle?
What are the differences between number and binary_float in oracle?
What is set operator oracle?