1. Write SQL statements to create a table from existing table. What are the advantages of creating a table from existing table?
2. What do you mean by 'view'? What are its different types? Differentiate between updatable and non updatable 'view' with suitable examples. Also give proper syntax for creating 'view'.
3. Explain the difference between the Drop & Delete, Commit & Rollback and Alter & Update with suitable examples.
4. Read the case study given below and answer the question given at the end.