Deck 12: Sql Views SQL/PSM and Importing Data

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

The Oracle DBMS supports the SQL BEFORE trigger.

Answer 3

True

Question 4

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

Question 5

SQL views can be used to hide rows.

Question 6

SQL views are constructed from SELECT statements.

Question 7

SQL views contain their own data.

Question 8

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

Question 9

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

Question 10

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 11

SQL views can be used to hide columns.

Question 12

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

Question 13

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 14

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

Question 15

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

Question 16

An SQL virtual table is called a view.

Question 17

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

Question 18

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

Question 19

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

Question 20

SQL views can be used to hide complicated SQL syntax.

Question 21

SQL views are constructed from:

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

Question 22

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 23

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 24

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

Question 25

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

Question 26

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 27

An SQL virtual table is called a(n):

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

Question 28

The SQL Server DBMS supports the SQL BEFORE trigger.

Question 29

Microsoft Access supports standard SQL view statements.

Question 30

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 31

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 32

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

Question 33

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

Question 34

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

Question 35

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 36

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 37

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

Question 38

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

Question 39

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 40

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 41

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

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

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 44

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

Question 45

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 46

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

Question 47

SQL views are constructed from SQL ________ statements.

Question 48

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 49

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 50

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 51

The SQL statement ________ is used to modify a view.

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

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 55

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 56

SQL views can be used to hide table ________.

Question 57

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

Question 58

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 59

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 60

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 61

SQL views can be used to layer ________.

Question 62

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 63

What are SQL stored procedures and how are they used?

Question 64

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 65

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

Question 66

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

Question 67

What are SQL triggers and how are they used?

Question 68

How are SQL views handled in Microsoft Access?

Question 69

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 70

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.