UGC NET CSE | September 2013 | Part 2 | Question: 39

Question

Views are useful for ____ unwanted information, and for collecting together information from more than one relation into a single view.

• A. Hiding
• B. Deleting
• C. Highlighting
• D. All of the above

Answer 1

Answer A: hiding

What is a view?

• Views are subset of table.
• View also has set of records in the form of rows and columns.
• But it is created based on the records in one or more tables. 
• A table will have large number of data and table will be fired with specific frequently. In such case, instead of rewriting the query again and again, a name is given to the query and it will be called whenever it is required.
• Hence view is also called as named query or stored query.

Answer 2

Ans is A views are logical masks over table(s) to display selected information from multiple relation and hiding rest