Exam 7: Sql for Database Construction and Application Processing

SQL views can be used to provide a level of insulation between data processed by applications and the data actually stored in the database tables.

Which SQL keyword is used to add one or more rows of data to a table?

Which of the following is an SQL trigger Microsoft SQL Server supports?

What are SQL stored procedures and how are they used?

SQL triggers can be used when the DBMS receives a(n)________ request.

If the table PRODUCT has a column PRICE,and PRICE has the data type Numeric (8,2),the value 98765 stored in that field will be displayed by the DBMS as 98765.00.

Because SQL statements are table-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are accessed using ________.

Which keyword is used to remove one or more rows from a table?

SQL views are used ________.

Unlike application code,stored procedures are never distributed to the client computers.

Which SQL keyword is used to impose restrictions on a table,data or relationship?

A set of SQL statements stored in an application written in a standard programming language is called ________.

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

One advantage of using the CONSTRAINT command to define a primary key is that the database designer controls the name of the constraint.

The SQL keyword PRIMARY KEY is used to designate the column(s)that are the primary key for the table.

SQL triggers can be used with SQL operations INSERT,UPDATE,and DELETE.

An SQL virtual table is called ________.

Which SQL statement is used to retrieve view instances?

An SQL virtual table is called a view.

If the values in an SQL view are not changeable through the view itself,you may still be able to update the view by using unique application logic.In this case,the specific logic is placed in ________.