Question 1

Microsoft Access supports standard SQL view statements.

Accepted Answer

A) True 
 B)False

Question 2

The SQL Server DBMS supports the SQL BEFORE trigger.

Accepted Answer

A) True 
 B)False

Question 3

SQL triggers are used for all uses except ________.

Accepted Answer

A)  validity checking 
B)  providing default values 
C)  enforcing synchronization 
D)  enforcing data constraints 
E)  updating views 
A)  validity checking 
B)  providing default values 
C)  enforcing synchronization 
D)  enforcing data constraints 
E)  updating views

Question 4

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

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 } \
\hline654 & \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 CUSTOMERBalance 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 8

SQL views can be used to hide rows.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A)  increased network throughput 
B)  standardized processing 
C)  specialization among developers 
D)  less work 
E)  greater security 
A)  increased network throughput 
B)  standardized processing 
C)  specialization among developers 
D)  less work 
E)  greater security

Question 11

SQL views are constructed from SQL ________ statements.

Accepted Answer

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

Question 12

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 13

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 14

Correlated subqueries do exactly the same type of work as join queries.

Accepted Answer

A) True 
 B)False

Question 15

What is not a reason to use the SQL ALTER TABLE statement?

Accepted Answer

A)  Add triggers 
B)  Add columns 
C)  Drop columns 
D)  Add constraints 
E)  Modify columns 
A)  Add triggers 
B)  Add columns 
C)  Drop columns 
D)  Add constraints 
E)  Modify columns

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

The LEFT and RIGHT keywords can be used to include unmatched rows into the results.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Microsoft Access supports standard SQL view statements.

The SQL Server DBMS supports the SQL BEFORE trigger.

SQL triggers are used for all uses except ________.

SQL statements used to construct views cannot contain ________.

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

SQL views can be used to hide rows.

Microsoft Access queries ________.

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

SQL views are constructed from SQL ________ statements.

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

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

Correlated subqueries do exactly the same type of work as join queries.

What is not a reason to use the SQL ALTER TABLE statement?

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.

The LEFT and RIGHT keywords can be used to include unmatched rows into the results.

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

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

SQL view instances are retrieved using the ________.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 12: Introduce the topic of importing Microsoft Excel 2016 data into a database table

Microsoft Access supports standard SQL view statements.

The SQL Server DBMS supports the SQL BEFORE trigger.

SQL triggers are used for all uses except ________.

SQL statements used to construct views cannot contain ________.

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

SQL views can be used to hide rows.

Microsoft Access queries ________.

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

SQL views are constructed from SQL ________ statements.

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

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

Correlated subqueries do exactly the same type of work as join queries.

What is not a reason to use the SQL ALTER TABLE statement?

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.

The LEFT and RIGHT keywords can be used to include unmatched rows into the results.

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

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

SQL view instances are retrieved using the ________.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters