AceTheInterview
Jobs in Pune | Work better in teams | Socialize with friends | Submit Q&A | Tell a friend
Search site for 

Top 100 Interview Questions & Answers in a convenient and easy to read book!

“I bought this guide a few days ago to prepare for my interview with Oracle. Many of the questions they asked me were from this guide. I found this book absolutely great!”

– Ravi, California

Read more comments...

Interview Questions And Answers RSS Feed

Answers »

  1. Submitted By: raja — October 6, 2006
    -3 votes
      + -

    This is the answer for What is a SQL View ?

    An output of a query can be stored as a view. View acts like small table which meets our criterion.

  2. Submitted By: akbatra — October 6, 2006
    -1 votes
      + -

    View is a precomplied SQL query which is used to select data from one or more tables. A view is like a table but it doens’t physically take any space. Viw is a good way to present data in a particualr format if you use that query quite often.
    View can also be used to restrict users from accessing the tables directly.

  3. Submitted By: venk_man — October 6, 2006
    -1 votes
      + -

    View is a layer of abstraction on top of one or more tables.

    Going through several layered views to access data has a performance price.

  4. Submitted By: homemaker — October 6, 2006
    -1 votes
      + -

    venk_man , could you please let me know what an “abstraction” is and explain your answer further about why it leads to an increase in performance price? Thanks a lot.

  5. Submitted By: Hotshot — October 6, 2006
    -1 votes
      + -

    A view otherwise known as a virtual table is a mere window over the base tables in the database.

    This helps us gain a couple of advantages :
    1) Inherent security exposing only the data that is needed to be shown to the end user

    2) Views are updateable based on certain conditions. For example, updates can only be directed to one underlying table of the view. After modification if the rows or columns don’t comply with the conditions that the view was created with, those rows disappear from the view. You could use the CHECK OPTION with the view definition, to make sure that any updates to make the rows invalid will not be permitted to run.

    3) Views are not materialized (given a physical structure) in a database. Each time a view is queried the definition stored in the database is run against the base tables to retrieve the data. One exception to this is to create a clustered index on the view to make it persistant in the database. Once you create a clustered index on the view, you can create any number of non-clustered indexes on the view.

    Hope that helps!

  6. Leave an Answer/Comment

    To prove you're a person (not a spam script), type the security text shown in the picture. Click here to regenerate some new text.
    Click to hear an audio file of the anti-spam word

Our Sponsors
Our Sponsors
Contact Us | FAQ | Sitemap | Terms of Use | Privacy Policy | Tell a Friend

Copyright © 1999-2006 Jeeve Technologies LLC. All rights reserved.