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 actual and formal parameters?
What is oracle and what are its different editions?
What are the different types of trigger and explain its various uses and functions?
Will you be able to store pictures in the database?
Can we protect our pl/sql source code?
What are the differences between char and nchar in oracle?
How to open and close an explicit cursor in oracle?
Explain the truncate in oracle?
What is the maximum number of triggers that can be applied to a single table?
 What are the oracle DML commands possible through an update strategy?
What is columnar storage what is the advantage?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is oracle server autotrace in oracle?
How to execute a stored procedure in oracle?
What is snapshot is too old? Give and example for better understand.