Exam 12: James River Jewelry Project Questions

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 SalesRepNo RepName HireDate 654 Tones 01/02/1999 734 Smith 02/03/2000 345 Chen 01/25/1998 434 Johnson 11/23/1998 CUSTOMER CustNo CustName Balance SalesRepNo 9870 Winston 500 345 8590 Gonzales 350 434 7840 Harris 800 654 4870 Miles 100 345

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

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

What are SQL triggers and how are they used?

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

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

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

How are SQL views handled in Microsoft Access?

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

Microsoft Access ________ can use previously stored view equivalent Access queries the same way an SQL SELECT statement uses SQL views.

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

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

Microsoft Access queries:

The SQL command CREATE VIEW is used to create view structures.

SQL triggers can be used when the DBMS receives an UPDATE request.

Stored procedures have the advantage of greater security,decreased network traffic,SQL optimized by the DBMS compiler,and code sharing.

An SQL virtual table is called a(n):

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

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

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