Exam 7: SQL for Database Construction and Application Processing

Which SQL keyword is used to change one or more rows in a table?

The SQL keyword MODIFY is used to change the structure,properties or constraints of a table.

A stored program that is attached to a table or view is called ________.

The SQL keyword UNIQUE is used to define alternate keys.

If the values in an SQL view are changeable through the view itself,which SQL statement is used to change the values?

An SQL virtual table is called ________.

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of less work,standardized processing,and specialization among developers.

When a trigger is fired,the DBMS makes the appropriate data available to the trigger code.

An SQL virtual table is called a view.

Stored procedures have all these advantages except ________.

Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are treated as pseudofiles.

The SQL keyword used to limit column values to specific values is ________.

SQL views can be used to hide columns.

The SQL keyword DELETE is used to delete a table's structure.

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers all these advantages except ________.

If the values in an SQL view are changeable through the view itself,the SQL command UPDATE is used to change the values.

Because SQL statements are set-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are treated as ________.

The values in an SQL view are always changeable through the view itself.

Explain the essential format of the CREATE TABLE statement. Include an example.

The SQL Server DBMS supports the SQL BEFORE trigger.