Answered Questions

  • Nov 17 2005
    09:55 PM
    13063
    22

    What is Materialised View?
    • rekha

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: Renu

    • Jan 26th, 2007

    Materialized View stores both - definition of the view and rows resulted from execution of the viewMain disadvantage of materialized view is that, its contents get outdated when underlying base table is modified .U can refresh Materialized View using DBMS_MVIEW.REFRESH

    thiru

    • Jun 26th, 2014

    Its a one of the oracle object,its physical storage on the disk then (dbms_refresh)

    shanitha

    • Sep 11th, 2012

    Materialized view is a database object that contains the results of a query..

  • Sep 06 2004
    12:11 PM
    2700
    3

    What is a deadlock ? Explain .

     Two  processes wating to update the rows of a table which are locked by the other process then deadlock arises. In  a  database  environment  this will often happen because of not issuing proper  row  lock  commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically. These locks...

  • Sep 06 2004
    11:48 AM
    5951
    9

    What are the functions of SMON ?

    System  Monitor (SMON)  performs instance recovery at instance start-up. In a multiple instance system (one that uses the Parallel Server), SMON of one instance  can  also  perform instance recovery for other instance that have failed SMON also cleans up temporary segments that are no longer in use and recovers  dead  transactions  skipped  during ...

    SREDDY1987

    • Jun 30th, 2014

    Rollback means uncommitted transaction.
    Roll forward means committed transaction.

    msabuu

    • Nov 6th, 2007

    If server unplanned shutdown, Power failiure SMON Instant recovery. there is two type of Instant recovery 1st is Roll forward 2nd Roll back.Rollback means comitted transaction.Rollforward means uncommitted transaction.