Answered Questions

  • What de-normalization and when do you do it?

    hari prasad

    • Mar 19th, 2007

    When its a large data base and our main constraint is the  cost(time) than we concentrates on fast retriving .so we go for denormalization instade of joing(complex relation calculcus) too many table and be in much complexicity with hign normalization.

  • difference between view and table


    • Mar 26th, 2014

    I have created VIEW in oracle with more than one table and i tried to delete the record by using the command "delete viewname where fieldname = 3 and the record is get delete. Can you plz explain why this happed

    fayaz ahmad khan

    • Sep 23rd, 2013

    View is used for simplicity and for security of a table in simply a query can also called a view and a stored query which is used a lot of time then it can waste our time so a view is used to reduce a time confusion