SQL for Database Construction Questions

• What is not an advantage of stored procedures?
• The SQL statement to create a view is:
• 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.
• When using the SQL INSERT statement:
• The SQL ALTER statement can be used to:
• Which is NOT one of the most common types of SQL CHECK constraints?
• What is an advantage of placing computations in SQL views?
• The SQL command to create a table is:
• A reason for using an SQL view to hide columns is:
• What SQL structure is used to limit column values of a table?
• A view that contains a computed column can be easily updated.