Question: A view is called using the call statement like a stored procedure. What happens when a view is called? What command lists the names of

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?

Step by Step Solution

3.41 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!