Exam 7: SQL for Database Construction and Application Processing

SQL views are updatable when the view is based on a single table with no computed columns,and all non-null columns are present in the view.

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

The SQL keyword CONSTRAINT can be used in conjunction with the SQL keywords PRIMARY KEY and FOREIGN KEY.

To set a column value to an initial value that is selected according to some complicated business logic,you would use the SQL DEFAULT constraint with the CREATE TABLE command.

Rows in a table can be changed by using the SQL UPDATE statement.

According to the SQL-92 standard,statements used to construct views cannot contain ________.

Which of the following illustrates the authors' preferred style of defining a primary key?

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

A stored program that is attached to the database is called ________.

SQL views are constructed from SELECT statements.

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER Explain the use of the SQL statement CREATE TABLE.Do NOT discuss the ALTER statement in your answer,but DO include an example based on the SALESREP table in the General Sales database.

The Oracle DBMS supports the SQL BEFORE trigger.

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

Explain how relationships are created using SQL.Include an example.

SQL triggers are not used for ________.

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

One or more rows can be added to a table by using the SQL INSERT statement.

Which SQL keyword is used to delete a table's structure?

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

The SQL command used to create a virtual table is ________.