Deck 12: Introduce the topic of importing Microsoft Excel 2016 data into a database table

Question 1

One of the limitations of Microsoft Access 2016 is that is does not include application development tools.

Answer 1

False

Question 2

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

Answer 2

D

Question 3

The SQL Server DBMS supports the SQL BEFORE trigger.

Answer 3

False

Question 4

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

Question 5

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

A) BETWEEN INSERT
B) WHILE INSERT
C) DURING INSERT
D) AFTER INSERT
E) ALONG WITH INSERT

Question 6

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

Question 7

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 8

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 9

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

Question 10

The Oracle DBMS supports the SQL BEFORE trigger.

Question 11

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

Question 12

SQL triggers are used for all uses except ________.

A) validity checking
B) providing default values
C) enforcing synchronization
D) enforcing data constraints
E) updating views

Question 13

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

Question 14

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

Question 15

Importing Microsoft Excel data into a DMBS varies considerably from DBMS to DBMS.

Question 16

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

Question 17

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 18

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

A) ADD
B) UPDATE
C) CLEAN
D) FREE
E) NEW

Question 19

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

Question 20

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

Question 21

SQL views can be used to hide complicated SQL syntax.

Question 22

The LEFT and RIGHT keywords can be used to include unmatched rows into the results.

Question 23

SQL views can be used to hide rows.

Question 24

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

Question 25

What are SQL triggers and how are they used?

Question 26

Describe a situation where a SQL MERGE statement is appropriately used in a table.

Question 27

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

Question 28

SQL views can be used to hide columns.

Question 29

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

Question 30

Stored procedures have the advantage of all choices except ________.

A) greater security
B) data integrity through distributed copies
C) SQL optimized by the DBMS compiler
D) code sharing
E) decreased network traffic

Question 31

An SQL virtual table is called a view.

Question 32

SQL views contain their own data.

Question 33

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 34

SQL views are used for all except ________.

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

Question 35

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

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

Question 36

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 37

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

A) increased network throughput
B) standardized processing
C) specialization among developers
D) less work
E) greater security

Question 38

What is not a reason to use the SQL ALTER TABLE statement?

A) Add triggers
B) Add columns
C) Drop columns
D) Add constraints
E) Modify columns

Question 39

A relational database table meets the definition of a set.

Question 40

What are SQL stored procedures and how are they used?

Question 41

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 42

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

Question 43

Microsoft Access supports standard SQL view statements.

Question 44

SQL views are constructed from SELECT statements.

Question 45

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 46

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

Question 47

Similar to correlated subqueries,queries on recursive relationships use aliases (copies)of the same table.

Question 48

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

Question 49

Correlated subqueries do exactly the same type of work as join queries.

Question 50

Outer joins are completely supported in Microsoft Access.

Question 51

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

Question 52

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

Question 53

The SQL UNION operator is supported by all DBMS products.

Question 54

SQL views can be used to hide table ________.

Question 55

SQL views can be used to layer ________.

Question 56

Unlike typical subqueries,correlated subqueries creates "copies" of a table,and evaluate each row of the outer copy with every row of the inner copy.

Question 57

What is the first stage in the logical process flow of a User-Defined function?

A) Receive input from calling SQL statement
B) Preprocess parameter values
C) Process parameter values to create result(s)
D) Arrange results into a formal ResultSet
E) Output to calling SQL statement

Question 58

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 59

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

Question 60

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

Question 61

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

Question 62

The SQL statement ________ is used to modify a view.

Question 63

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 64

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 65

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 66

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

CUSTOMER

Using the CUSTOMERBalance 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 67

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 68

SQL views are constructed from SQL ________ statements.

Question 69

SQL views are constructed from ________.

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

Question 70

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

Question 71

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 72

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

Question 73

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 74

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

Question 75

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 76

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

Question 77

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 78

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

Question 79

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

Question 80

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.