Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The SQL statement ________ is used to modify a view.

Accepted Answer

ALTER VIEW

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

What are SQL stored procedures and how are they used?

Accepted Answer

An SQL stored procedure is a stored prog

Question 5

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

Accepted Answer

We will name this view as Cust

Question 6

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 7

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 8

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:

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

SQL views are constructed from SQL ________ statements.

Accepted Answer

The answer of SQL views are constructed from SQL ________...

Question 12

SQL views can be used to layer ________.

Accepted Answer

built-in S

Question 13

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 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A)  INSERT 
B)  UPDATE 
C)  DELETE 
D)  A and B 
E)  A, B, and C 
A)  INSERT 
B)  UPDATE 
C)  DELETE 
D)  A and B 
E)  A, B, and C

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

SQL views can be used to hide table ________.

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

SQL views can be used to hide rows.

Accepted Answer

A) True 
 B)False

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

The SQL statement ________ is used to modify a view.

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

What are SQL stored procedures and how are they used?

The SQL statement used to modify a view is:

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

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 stored program that is attached to a table or view is called a stored procedure.

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

SQL views are constructed from SQL ________ statements.

SQL views can be used to layer ________.

SQL triggers are used for ________.

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

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

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.

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

SQL views can be used to hide table ________.

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

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 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 views can be used to display the results of computed columns.

The SQL statement ________ is used to modify a view.

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

What are SQL stored procedures and how are they used?

The SQL statement used to modify a view is:

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

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 stored program that is attached to a table or view is called a stored procedure.

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

SQL views are constructed from SQL ________ statements.

SQL views can be used to layer ________.

SQL triggers are used for ________.

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

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

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.

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

SQL views can be used to hide table ________.

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

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