Question 1

SQL statements used to construct views cannot contain:

Accepted Answer

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

Question 2

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 3

SQL views are used:

Accepted Answer

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

Stored procedures have the advantage of ________.

Accepted Answer

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

Question 5

SQL views can be used to hide complicated SQL syntax.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is an SQL trigger that Oracle 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 10

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 { Tones } & 01 / 02 / 1999 \
\hline 734 & \text { Smith } & 02 / 03 / 2000 \
\hline 345 & \text { Chen } & 01 / 25 / 1998 \
\hline 434 & \text { Tohnson } & 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}$$ 
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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

SQL views are constructed from SELECT statements.

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 } \
\hline 654 & \text { Tones } & 01 / 02 / 1999 \
\hline 734 & \text { Smith } & 02 / 03 / 2000 \
\hline 345 & \text { Chen } & 01 / 25 / 1998 \
\hline 434 & \text { Tohnson } & 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}$$ 
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.

Accepted Answer

The SQL query code is:
SELECT

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

The Oracle DBMS supports the SQL BEFORE trigger.

Accepted Answer

A) True 
 B)False

Question 20

SQL views can be used to hide columns.

Accepted Answer

A) True 
 B)False

SQL statements used to construct views cannot contain:

Microsoft Access:

SQL views are used:

Stored procedures have the advantage of ________.

SQL views can be used to hide complicated SQL syntax.

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

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

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

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

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.

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

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.

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

SQL views are constructed from SELECT statements.

SQL views are constructed from:

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

The Oracle DBMS supports the SQL BEFORE trigger.

SQL views can be used to hide columns.

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 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 12: James River Jewelry Project Questions

SQL statements used to construct views cannot contain:

Microsoft Access:

SQL views are used:

Stored procedures have the advantage of ________.

SQL views can be used to hide complicated SQL syntax.

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

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

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

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

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.

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

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.

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

SQL views are constructed from SELECT statements.

SQL views are constructed from:

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

The Oracle DBMS supports the SQL BEFORE trigger.

SQL views can be used to hide columns.

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 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters