To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
What SQL structure is used to limit column values of a table?
What SQL structure is used to limit column values of a table?
The SQL command to create a table is:
The SQL command to create a table is:
Which is NOT one of the most common types of SQL CHECK constraints?
Which is NOT one of the most common types of SQL CHECK constraints?
Which of the following is an SQL trigger supported by Oracle?
Which of the following is an SQL trigger supported by Oracle?
For what purposes are views used?
For what purposes are views used?
A ________ is a stored program that is attached to a table or a view.
A ________ is a stored program that is attached to a table or a view.
What is not an advantage of stored procedures?
What is not an advantage of stored procedures?
What is an advantage of placing computations in SQL views?
What is an advantage of placing computations in SQL views?
SQL views can be used to hide:
SQL views can be used to hide:
The DROP TABLE statement:
The DROP TABLE statement:
The SQL statement to create a view is:
The SQL statement to create a view is:
What is an SQL virtual table that is constructed from other tables?
What is an SQL virtual table that is constructed from other tables?
A reason for using an SQL view to hide columns is:
A reason for using an SQL view to hide columns is:
Which of the following is NOT a type of SQL constraint?
Which of the following is NOT a type of SQL constraint?
A ________ is a program that performs some common action on database data and that is stored in the database.
A ________ is a program that performs some common action on database data and that is stored in the database.
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
The SQL ALTER statement can be used to:
The SQL ALTER statement can be used to:
When using the SQL INSERT statement:
When using the SQL INSERT statement: