Question 1

Microsoft Access queries:

Accepted Answer

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

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

Accepted Answer

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

Question 3

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

Accepted Answer

CREATE VIE

Question 4

Microsoft Access supports standard SQL view statements.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) ALTER EXISTING VIEW ViewName AS. 
B) ALTER VIEW ViewName AS. 
C) DELETE VIEW ViewName. 
D) DROP EXISTING VIEW ViewName. 
E) DROP VIEW ViewName. 
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 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

SQL views are constructed from:

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The answer of The SQL keyword ________ can be used...

Question 14

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

Accepted Answer

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

Question 15

SQL triggers are used for ________.

Accepted Answer

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

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 } \
\hline 654 & \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
\end{array}$

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

Accepted Answer

An SQL view is a virtual table construct

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

SQL views can be used to layer ________.

Accepted Answer

built-in S

Question 20

SQL views can be used to hide rows.

Accepted Answer

A) True 
 B)False

Microsoft Access queries:

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

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

Microsoft Access supports standard SQL view statements.

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

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

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

SQL views are constructed from:

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

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

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

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

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

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

SQL triggers are used for ________.

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

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

SQL views can be used to layer ________.

SQL views can be used to hide rows.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 12: Sql Views SQL/PSM and Importing Data

Microsoft Access queries:

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

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

Microsoft Access supports standard SQL view statements.

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

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

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

SQL views are constructed from:

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

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

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

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

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

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

SQL triggers are used for ________.

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

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

SQL views can be used to layer ________.

SQL views can be used to hide rows.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters