Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of ________.

Accepted Answer

A)  less work
B)  standardized processing
C)  specialization among developers
D)  A and B
E)  A,B,and C E

Question 3

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

Accepted Answer

A)  BEFORE
B)  INSTEAD OF
C)  AFTER
D)  B and C only
E)  A,B,and C D

Question 4

Since an SQL view is essentially a stored query,Microsoft Access queries can be used to implement SQL view equivalents.

Accepted Answer

A) True 
 B)False

Question 5

SQL views can be used to hide table ________.

Accepted Answer

The answer of SQL views can be used to hide...

Question 6

Which of the following is not an SQL trigger?

Accepted Answer

A)  BEFORE UPDATE
B)  INSTEAD OF UPDATE
C)  BEFORE INSERT
D)  INSTEAD OF CONSTRAINT
E)  AFTER DELETE

Question 7

Microsoft Access queries cannot use previously stored view equivalent Access queries.

Accepted Answer

A) True 
 B)False

Question 8

The SQL statement DROP VIEW ViewName is used to delete a view from a database.

Accepted Answer

A) True 
 B)False

Question 9

Since an SQL view is essentially a stored query,Microsoft Access ________ can be used to implement SQL view equivalents.

Accepted Answer

The answer of Since an SQL view is essentially a...

Question 10

The SQL statement ________ is used to delete a view from a database.

Accepted Answer

The answer of The SQL statement ________ is used to...

Question 11

SQL views are constructed from SQL ________ statements.

Accepted Answer

The answer of SQL views are constructed from SQL ________...

Question 12

When an SQL SELECT statement is used to retrieve data from a view instance,the maximum number of columns that can be specified in the SELECT is the same as the number of columns in the table underlying the view.

Accepted Answer

A) True 
 B)False

Question 13

What are SQL stored procedures and how are they used?

Accepted Answer

The answer of What are SQL stored procedures and how...

Question 14

An SQL virtual table is called a(n)________.

Accepted Answer

The answer of An SQL virtual table is called a(n)________....

Question 15

SQL view instances are retrieved using the:

Accepted Answer

A)  SQL CREATE statement.
B)  SQL DELETE statement.
C)  SQL INSERT statement.
D)  SQL SELECT statement.
E)  SQL UPDATE statement.

Question 16

The SQL statement used to modify a view is:

Accepted Answer

A)  ALTER EXISTING VIEW ViewName AS.
B)  ALTER VIEW ViewName AS.
C)  DROP EXISTING VIEW ViewName.
D)  DROP VIEW ViewName.
E)  MODIFY VIEW ViewName AS.

Question 17

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

Accepted Answer

A)  INSERT
B)  UPDATE
C)  DELETE
D)  A and B
E)  A,B,and C

Question 18

SQL views can be used to display the results of ________.

Accepted Answer

The answer of SQL views can be used to display...

Question 19

Based on the tables below,which of the following SQL commands would create an SQL view named CustomerSalesRep that could be used to display CustNo,CustName,RepName? GENERAL SALES DATABASE:
SALESREP
$\begin{array}{l|l|l}
\text { SalesRepNo } & \text { RepName } & \text { HireDate } \
\hline 654 & \text { Tones } & 01 / 02 / 1999 \
\hline 734 & \text { Smith } & 02 / 03 / 2000 \
\hline 345 & \text { Chen } & 01 / 25 / 1998 \
\hline 434 & \text { Tohnson } & 11 / 23 / 1998 \
\hline
\end{array}$
CUSTOMER
$\begin{array}{l|l|l|l}
\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}$

Accepted Answer

A)  SELECT CustNo,CustName,RepName FROM SALESREP,CUSTOMER;
B)  SELECT CustNo,CustName,RepName FROM SALESREP,CUSTOMERWHERE CustNo=*;
C)  SELECT CustNo,CustName,RepName FROM SALESREP,CUSTOMERWHERE SALEREP,SalesRepNo = CUSTOMER,SalesRepNo;
D)  CREATE VIEW CustomerSalesRep AS SELECT CustNo,CustName,RepNameFROM SALESREP,CUSTOMERWHERE CustNo=*;
E)  CREATE VIEW CustomerSalesRep AS SELECT CustNo,CustName,RepNameFROM SALESREP,CUSTOMERWHERE SALEREP,SalesRepNo = CUSTOMER,SalesRepNo;

Question 20

SQL views can be used to hide columns.

Accepted Answer

A) True 
 B)False

Exam 12: Sql Views SQL/PSM and Importing Data

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

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of ________.

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

Since an SQL view is essentially a stored query,Microsoft Access queries can be used to implement SQL view equivalents.

SQL views can be used to hide table ________.

Which of the following is not an SQL trigger?

Microsoft Access queries cannot use previously stored view equivalent Access queries.

The SQL statement DROP VIEW ViewName is used to delete a view from a database.

Since an SQL view is essentially a stored query,Microsoft Access ________ can be used to implement SQL view equivalents.

The SQL statement ________ is used to delete a view from a database.

SQL views are constructed from SQL ________ statements.

When an SQL SELECT statement is used to retrieve data from a view instance,the maximum number of columns that can be specified in the SELECT is the same as the number of columns in the table underlying the view.

What are SQL stored procedures and how are they used?

An SQL virtual table is called a(n)________.

SQL view instances are retrieved using the:

The SQL statement used to modify a view is:

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

SQL views can be used to display the results of ________.

SQL views can be used to hide columns.