Question 1

An SQL virtual table is called a view.

Accepted Answer

A) True 
 B)False

Question 2

Microsoft Access supports standard SQL view statements.

Accepted Answer

A) True 
 B)False

Question 3

Microsoft Access queries cannot use previously stored view equivalent Access queries.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not an SQL trigger?

Accepted Answer

A)  BEFORE UPDATE 
B)  INSTEAD OF UPDATE 
C)  BEFORE INSERT 
D)  INSTEAD OF CONSTRAINT 
E)  AFTER DELETE 
A)  BEFORE UPDATE 
B)  INSTEAD OF UPDATE 
C)  BEFORE INSERT 
D)  INSTEAD OF CONSTRAINT 
E)  AFTER DELETE

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

SQL view instances are retrieved using the:

Accepted Answer

A)  SQL CREATE statement. 
B)  SQL DELETE statement. 
C)  SQL INSERT statement. 
D)  SQL SELECT statement. 
E)  SQL UPDATE statement. 
A)  SQL CREATE statement. 
B)  SQL DELETE statement. 
C)  SQL INSERT statement. 
D)  SQL SELECT statement. 
E)  SQL UPDATE statement.

Question 7

SQL triggers can be used when the DBMS receives an INSERT request.

Accepted Answer

A) True 
 B)False

Question 8

SQL views contain their own data.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The SQL Server DBMS supports the SQL BEFORE trigger.

Accepted Answer

A) True 
 B)False

An SQL virtual table is called a view.

Microsoft Access supports standard SQL view statements.

Microsoft Access queries cannot use previously stored view equivalent Access queries.

Which of the following is not an SQL trigger?

SQL view instances are retrieved using the:

SQL triggers can be used when the DBMS receives an INSERT request.

SQL views contain their own data.

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

The SQL Server DBMS supports the SQL BEFORE trigger.

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

An SQL virtual table is called a view.

Microsoft Access supports standard SQL view statements.

Microsoft Access queries cannot use previously stored view equivalent Access queries.

Which of the following is not an SQL trigger?

SQL view instances are retrieved using the:

SQL triggers can be used when the DBMS receives an INSERT request.

SQL views contain their own data.

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

The SQL Server DBMS supports the SQL BEFORE trigger.

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