what is the difference between rollback & commit?
can a foreign key has null value?
Answer Posted / aditi
commit save the transactions done after the last commit and rollback undo all transactions after last commit
Yes foreign key can have null value
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Explain the characteristics of oracle dba?
Is the After report trigger fired if the report execution fails ?
How will you differentiate between varchar & varchar2?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to declare a local variable?
Explain about functional dependency and its relation with table design?
What are the components of logical database structure in oracle database?
How to write an inner join with the where clause in oracle?
What is varray?
What are the benefits of ordbms?
What is a directory object?
Explain the use of show option in imp command.
How to create a table interactively?
How to create a table index?