Question 1

Microsoft Access ________.

Accepted Answer

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 
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 2

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 
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 3

You can add columns to a preexisting table using the INSERT clause in an SQL ALTER TABLE statement.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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.

Accepted Answer

A) True 
 B)False

Question 8

A relational database table meets the definition of a set.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

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 
A)  BEFORE 
B)  INSTEAD OF 
C)  AFTER 
D)  B and C only 
E)  A, B, and C

Question 11

The SQL statement ________ is used to modify a view.

Accepted Answer

ALTER VIEW

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

SQL views can be used to layer ________.

Accepted Answer

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

Question 15

The SQL UNION operator is supported by all DBMS products.

Accepted Answer

A) True 
 B)False

Question 16

Use the database below to answer the following question.
GENERAL SALES DATABASE:
SALESREP
 $$\begin{array} { l | l | l | } 
\hline \text { SalesRepNo } & \text { RepName } & \text { HireDate } \
\hline654 & \text { Jones } & 01 / 02 / 1999 \
\hline 734 & \text { Smith } & 02 / 03 / 2000 \
\hline 345 & \text { Chen } & 01 / 25 / 1998 \
\hline 434 & \text { Johnson } & 11 / 23 / 1998 \
\hline
\end{array}$$ 
CUSTOMER
 $$\begin{array} { | l | l | l | l | } 
\hline \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 \
\hline
\end{array}$$ 
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.

Accepted Answer

The SQL code to create the CustomerSales

Question 17

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

Accepted Answer

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 
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 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.

Accepted Answer

A) True 
 B)False

Question 19

An SQL virtual table is called a view.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Microsoft Access ________.

The SQL statement used to modify a view is ________.

You can add columns to a preexisting table using the INSERT clause in an SQL ALTER TABLE statement.

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

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

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

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.

A relational database table meets the definition of a set.

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

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

The SQL statement ________ is used to modify a view.

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

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

SQL views can be used to layer ________.

The SQL UNION operator is supported by all DBMS products.

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

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.

An SQL virtual table is called a view.

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

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

Microsoft Access ________.

The SQL statement used to modify a view is ________.

You can add columns to a preexisting table using the INSERT clause in an SQL ALTER TABLE statement.

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

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

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

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.

A relational database table meets the definition of a set.

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

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

The SQL statement ________ is used to modify a view.

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

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

SQL views can be used to layer ________.

The SQL UNION operator is supported by all DBMS products.

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

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.

An SQL virtual table is called a view.

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

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters