Question 1

The Oracle DBMS supports the SQL BEFORE trigger.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

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

The SQL statement ________ is used to modify a view.

Accepted Answer

ALTER VIEW

Question 7

SQL views contain their own data.

Accepted Answer

A) True 
 B)False

Question 8

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 9

SQL views are constructed from SELECT statements.

Accepted Answer

A) True 
 B)False

Question 10

What are SQL triggers and how are they used?

Accepted Answer

An SQL trigger is a stored program that

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:

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 12

An SQL virtual table is called a view.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

How are SQL views handled in Microsoft Access?

Accepted Answer

Microsoft Access does not support views

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

The answer of SQL statements used to construct views cannot...

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.

Accepted Answer

A) True 
 B)False

Question 18

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 19

An SQL virtual table is called a(n):

Accepted Answer

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

Question 20

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

The Oracle DBMS supports the SQL BEFORE trigger.

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

SQL statements used to construct views cannot contain:

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

The SQL statement ________ is used to modify a view.

SQL views contain their own data.

SQL views are used:

SQL views are constructed from SELECT statements.

What are SQL triggers and how are they used?

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:

An SQL virtual table is called a view.

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

How are SQL views handled in Microsoft Access?

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

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

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.

Microsoft Access:

An SQL virtual table is called a(n):

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

The Oracle DBMS supports the SQL BEFORE trigger.

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

SQL statements used to construct views cannot contain:

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

The SQL statement ________ is used to modify a view.

SQL views contain their own data.

SQL views are used:

SQL views are constructed from SELECT statements.

What are SQL triggers and how are they used?

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:

An SQL virtual table is called a view.

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

How are SQL views handled in Microsoft Access?

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

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

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.

Microsoft Access:

An SQL virtual table is called a(n):

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