• Home
  • manimehra905 Answers

Answered Questions

  • Apr 19 2010
    08:30 AM
    8836
    18

    ALTER Row
    • sweetysmarty

    We are UPDATING a field in SQL and ALTER the row also. After giving the COMMIT command the system is crashed. What will happen to the commands given, whether it will UPDATE and ALTER the table or not?

  • Mar 09 2009
    09:16 AM
    5708
    9

    Intent Shared Lock

    • karpagap

    Which one of the following is descriptive of the effect of an Intent Shared Lock on other transactions? CHOICE1: A Read Lock that prevents writes CHOICE2: A Read Lock that prevents other reads CHOICE3: A Read Lock that prevents more restrictive Locks CHOICE4: A Read Lock that allows other reads CHOICE5: A Read Lock that allows writes (Dirty Reads)

    hmounir

    • May 3rd, 2010

    A Read Lock that allows other reads  Shared (S) locks allow concurrent transactions to read (SELECT) a resource under pessimistic concurrency control.No other transactions can modify the data whi...

  • Oct 23 2008
    09:45 AM
    15340
    23

    View - Base Tables
    • manu4sql

    Does View occupy memory? If we delete the base table of existing view, What happens?

    Star Read Best Answer

    Editorial / Best Answer

    Mad Hatter  

    • Member Since Nov-2008 | Nov 4th, 2008

    View does not occupy memory, but Oracle keeps view code in its dictionary (you can check in user_views, for example)
    If you delete the base table, the view becomes INVALID.
    In order to make it valid again, you have to ether build the deleted table again, or create anotehr view with the same name and structure as deleted table, or create synonym with the same name as deleted table, which will point to the table with the same structure.

    pkshve

    • Sep 12th, 2010

    Views are database objects - they are just SQL code stored in database which will be executed every single time the view is called. Database will check the existance of columns and tables in the base ...