What is a view? Why use it ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a view? Why use it ?

A view is a virtual table made up of data from base tables and other views, but not stored separately.

(Continued on next question...)

Other Job Interview Questions

• What is the retriction on using UNION in embedded SQL?
• When is it necessary to create a table index?
• When is it necessary to create a table index?
• What is the difference between group by and order by ?
• What is a cursor?
• What is an object?
• What is a synonym?
• What do you accomplish by GROUP BY ... HAVING clause ?
• How do you find the maximum value in a column?
• What are the column name qualifiers?
• More...