| 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. |