what is the difference between rollback & commit?
can a foreign key has null value?
Answer Posted / anjani kumar
Commits and Rollback both complete our transaction cycle.
we use commit to store the DML changes into DB but Rollback
performs undo to our DML transaction
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is ADDM Advisor in Oracle?
Explain self joins in oracle?
Is a rollback possible to any savepoint?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is Java Pool in Oracle?
How to omit columns with default values in insert statement in oracle?
How to convert characters to times in oracle?
What happens if you use a wrong connect identifier?
What is clustered table in Oracle?
Explain what does a control file contain?
Difference between the “verify” and “feedback” command?
How to define a record variable to store a table row?
What are ddl statements in oracle?
Where do we use decode and case statements?