ROLLBACK  retracts  any of the changes resulting from the SQL statements in the transaction.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 5th, 2006

ROLLBACK:  This is just like UNDO in MSOFFICE but can not  REDO, means what ever changes You made after any commit/rollback or A DDL command they will not be saved into database . when rollb...

Answer Question  Select Best Answer

A  Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time.

nanibabu

• May 23rd, 2006

it will reads the data firsrt and then executes the transaction

poornima

• Apr 11th, 2006

This is very nice job to clarify our doubts

Answer Question  Select Best Answer

COST and RULE.

Chiranjeevi Manne

• Nov 9th, 2005

One can specify COST , RULE or CHOOSE for OPTIMIZER _MODE in init.ora file

Answer Question  Select Best Answer