Answered Questions

  • What will happen after commit statement ?

              Cursor C1 is          Select empno,          ename from emp;          Begin               open C1;           ...

    Vivek

    • Jun 29th, 2012

    After committing first oracle will commit the transaction into redo log file and then Data file. The data block will remain into the memory until the logical reads are going on. Oracle use LRU algorit...