The SQL statement to create a view is:

More Questions from SQL for Database Construction

• The DROP TABLE statement:
• A ________ is a program that performs some common action on database data and that is stored in the database.
• Which of the following is NOT a type of SQL constraint?
• What is an SQL virtual table that is constructed from other tables?
• For what purposes are views used?
• To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
• Which of the following is an SQL trigger supported by Oracle?
• Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
• SQL views can be used to hide:
• A ________ is a stored program that is attached to a table or a view.

Discussion & Comments