A view is called using the call statement like a stored procedure. 

1. What happens when a view is called?
2. What command lists the names of tables and views but does not provide information about the object type?
3. What command lists the names of tables and views and provides information about the object type
4. What must be added to the show create view command to make the output more a more readable format?
5. How can the name of a view be changed without deleting it?
6. A view is deleted with the drop table command. (yes/No)
7. Privileges can be granted on a view by giving the user what privilege?
8. If a user has privilege to query a view, they do not need privileges on the underlying tables.
9. Another name for a view is?

Answer rating: 100% (QA)

Question 1 Answer When a view is called the database engine executes the underlying qu... View the full answer