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
How to list all user accounts in oracle?
How to create a new table in oracle?
What are transaction isolation levels supported by oracle?
Explain the use of full option in exp command.
How to drop a stored function?
What is the implicit cursor in oracle?
How different is ms access and oracle?
What is oracle data type?
How many data types are supported?
What happens to indexes if you drop a table?
How many categories of data types in oracle?
What is execute immediate in oracle?
what is port in oracle? how is it related to database application.
How to connect to a local oracle 10g xe server?
How to use existing values in update statements using oracle?