Deck 12: James River Jewelry Project Questions

Question 1

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

Answer 1

True

Question 2

An SQL virtual table is called a view.

Answer 2

True

Question 3

SQL triggers use the SQL keywords BEFORE,INSTEAD OF,and AFTER.

Answer 3

True

Question 4

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

Question 5

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

Question 6

SQL views can be used to hide columns.

Question 7

SQL views can be used to hide rows.

Question 8

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

Question 9

The Oracle DBMS supports the SQL BEFORE trigger.

Question 10

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

Question 11

SQL views contain their own data.

Question 12

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

Question 13

SQL views are constructed from SELECT statements.

Question 14

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

Question 15

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

Question 16

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

Question 17

SQL views can be used to hide complicated SQL syntax.

Question 18

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.

Question 19

The SQL keyword ORDER BY can be used with SELECT statements that are retrieving data from view instances to sort the results of the SELECT.

Question 20

The SQL command SELECT is used to retrieve data from view instances.

Question 21

An SQL virtual table is called a(n):

A) CHECK constraint.
B) view.
C) embedded SQL statement.
D) trigger.
E) stored procedure.

Question 22

The SQL Server DBMS supports the SQL BEFORE trigger.

Question 23

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

Question 24

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:

A) in the table underlying the view.
B) in the VIEW specification.
C) in the ORDER BY clause.
D) in the HAVING clause.
E) that have aliases.

Question 25

The SQL statement used to modify a view is:

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 26

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

CUSTOMER

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

Question 27

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

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

Question 28

A stored program that is stored within the database and compiled when used is called a trigger.

Question 29

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

Question 30

SQL views are constructed from:

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

Question 31

SQL view instances are retrieved using the:

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

Question 32

SQL views are used:

A) to hide columns or rows.
B) to display the results of computations.
C) to hide complicated SQL syntax.
D) to layer built-in functions.
E) All of the above

Question 33

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of less work,standardized processing,and specialization among developers.

Question 34

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

Question 35

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

Question 36

Microsoft Access supports standard SQL view statements.

Question 37

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

Question 38

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

Question 39

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

A) SQL keyword ORDER BY.
B) SQL keyword LIKE.
C) SQL keyword BETWEEN.
D) SQL keyword NULL.
E) SQL keyword NOT NULL.

Question 40

SQL statements used to construct views cannot contain:

A) the SELECT clause.
B) the FROM clause.
C) the WHERE clause.
D) the ORDER BY clause.
E) the LIKE keyword.

Question 41

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

Question 42

Which of the following is not an SQL trigger?

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

Question 43

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

A) a CHECK constraint
B) a view
C) embedded SQL
D) a trigger
E) a stored procedure

Question 44

SQL views are constructed from SQL ________ statements.

Question 45

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

Question 46

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

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

Question 47

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

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

Question 48

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

A) a CHECK constraint
B) a view
C) embedded SQL
D) a trigger
E) a stored procedure

Question 49

Stored procedures have the advantage of ________.

A) greater security
B) decreased network traffic
C) SQL optimized by the DBMS compiler
D) code sharing
E) All of the above

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

SQL views can be used to hide table ________.

Question 55

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

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

Question 56

Microsoft Access queries:

A) can use previously stored view equivalent Access queries.
B) cannot use previously stored view equivalent Access queries for any purpose.
C) cannot use previously stored view equivalent Access queries to hide rows.
D) cannot use previously stored view equivalent Access queries to hide columns.
E) cannot use previously stored view equivalent Access queries to hide complicated SQL syntax.

Question 57

Microsoft Access:

A) supports standard SQL view statements.
B) only supports SQL view statements as QBE constructions.
C) can store a view equivalent Access query.
D) can store a view equivalent Access query but does not provide a means to use it.
E) cannot store any database object that is equivalent to an SQL view.

Question 58

Which of the following is an SQL trigger that Oracle supports?

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

Question 59

The SQL statement ________ is used to modify a view.

Question 60

SQL triggers are used for ________.

A) validity checking
B) providing default values
C) updating views
D) A and B
E) A, B, and C

Question 61

What are SQL triggers and how are they used?

Question 62

Use the database below to answer the following question.
GENERAL SALES DATABASE:
SALESREP

CUSTOMER

What is an SQL view,and what is it used for? Include an example based on the CUSTOMER table of the General Sales Database.

Question 63

Use the database below to answer the following question.
GENERAL SALES DATABASE:
SALESREP

CUSTOMER

Using the CUSTOMER.Balance column as the column providing the data,create a view to display the results of a computed column.Specifically,assume that all customers are required to maintain a minimum balance of 100,and use the view to display customer name and a number named BalanceOverMinimum that calculates (Balance - 100)for all customers in the GENERAL SALES DATABASE.

Question 64

How are SQL views handled in Microsoft Access?

Question 65

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

Question 66

Use the database below to answer the following question.
GENERAL SALES DATABASE:
SALESREP

CUSTOMER

Write the SQL statement to create a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name SaleRepresentativeName from the GENERAL SALES DATABASE.

Question 67

Use the database below to answer the following question.
GENERAL SALES DATABASE:
SALESREP

CUSTOMER

Given that a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name as SalesRepresentativeName has been created for the GENERAL SALES DATABASE,write the SQL code to use the view to display the customer name and associated sales rep name sorted by customer name.

Question 68

SQL views can be used to layer ________.

Question 69

What are SQL stored procedures and how are they used?

Question 70

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