FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Sql Views SQL/PSM and Importing Data

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

SQL views are constructed from:

A) CREATE statements.
B) INSERT statements.
C) UPDATE statements.
D) SELECT statements.
E) VIEW statements.

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

SQL views can be used to layer ________.

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

SQL triggers are used for providing default values,validity checking,updating views,and performing referential integrity actions.

SQL views can be used to layer built-in SQL functions.

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

Use the database below to answer the following question. GENERAL SALES DATABASE: SALESREP $\begin{array}{|l|l|l|}\hline \text { SalesRepNo } & \text { RepName } & \text { HireDate } \\\hline 654 & \text { Jones } & 01 / 02 / 1999 \\\hline 734 & \text { Smith } & 02 / 03 / 2000 \\\hline 345 & \text { Chen } & 01 / 25 / 1998 \\\hline 434 & \text { Johnson } & 11 / 23 / 1998 \\\hline\end{array}$ CUSTOMER $\begin{array}{|l|l|l|l|}\hline \text { CustNo } & \text { CustName } & \text { Balance } & \text { SalesRepNo } \\\hline 9870 & \text { Winston } & 500 & 345 \\\hline 8590 & \text { Gonzales } & 350 & 434 \\\hline 7840 & \text { Harris } & 800 & 654 \\\hline 4870 & \text { Miles } & 100 & 345\end{array}$ What is an SQL view,and what is it used for? Include an example based on the CUSTOMER table of the General Sales Database.

The SQL keyword ________ can be used with SELECT statements retrieving view instances to sort the results of the SELECT.

The SQL statement ALTER EXISTING VIEW ViewName AS is used to modify a view.

The SQL statement used to delete a view from a database is:

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

Although it cannot be used in creating an SQL VIEW,the SQL SELECT statements retrieving view instances can include:

SQL views can be used to hide rows.

SQL views can be used to display the results of computed columns.

Microsoft Access supports standard SQL view statements.

Microsoft Access queries:

SQL statements used to construct views cannot contain the WHERE clause.

SQL triggers are used for ________.