Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 20. Creating and Using Views and Synonyms
Q&A
Q1:
How can a view contain data but take no storage space?
A1:
A view does not contain data. A view is a virtual table or a stored query. The only space required for a view is for the actual view creation statement, called the view definition.
Q2:
What happens to the view if a table from which a view was created is dropped?
A2:
The view is invalid because the underlying data for the view no longer exists.
Q3:
What are the limits on naming the synonym when creating synonyms?
A3:
This is implementation-specific. However, the naming convention for synonyms in most major implementations follows the same rules that apply to the tables and other objects in the database.