what is the difference between rollback & commit?
can a foreign key has null value?
Answer Posted / ven
Commit made changes permenant to the database.
Rollback made undo the changes.
Yes, FK has null values.
| Is This Answer Correct ? | 23 Yes | 2 No |
Post New Answer View All Answers
Explain an extent?
Explain table?
Explain what are the different type of segments?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to retrieve values from data fields in record variables?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the use of aggregate functions in oracle?
Explain implicit cursor.
How to start a new transaction in oracle?
Explain an exception?
What is an oracle user account?
Explain compound trigger in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What are operators in oracle?
is there a tool to trace queries, like profiler for sql server?