Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

How are SQL views handled in Microsoft Access?

Accepted Answer

Microsoft Access does not support views

Question 3

The SQL MERGE statement is,effectively,the combination of the SQL INSERT and SQL UPDATE statements.

Accepted Answer

A) True 
 B)False

Question 4

Importing Microsoft Excel data into a DMBS varies considerably from DBMS to DBMS.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

The Oracle DBMS supports the SQL BEFORE trigger.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

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

Accepted Answer

A) True 
 B)False

Question 13

What are SQL triggers and how are they used?

Accepted Answer

An SQL trigger is a stored program that

Question 14

The SQL command ________ is used to create a virtual table.

Accepted Answer

CREATE VIE

Question 15

The SQL statement ________ is used to delete a view from a database.

Accepted Answer

The answer of The SQL statement ________ is used to...

Question 16

SQL views are used for all except ________.

Accepted Answer

A)  to backup preexisting tables 
B)  to display the results of computations 
C)  to hide complicated SQL syntax 
D)  to layer built-in functions 
E)  to hide columns or rows 
A)  to backup preexisting tables 
B)  to display the results of computations 
C)  to hide complicated SQL syntax 
D)  to layer built-in functions 
E)  to hide columns or rows

Question 17

Unlike typical subqueries,correlated subqueries creates "copies" of a table,and evaluate each row of the outer copy with every row of the inner copy.

Accepted Answer

A) True 
 B)False

Question 18

SQL views can be used to hide columns.

Accepted Answer

A) True 
 B)False

Question 19

Outer joins are completely supported in Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 20

SQL views can be used to hide table ________.

Accepted Answer

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

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

How are SQL views handled in Microsoft Access?

The SQL MERGE statement is,effectively,the combination of the SQL INSERT and SQL UPDATE statements.

Importing Microsoft Excel data into a DMBS varies considerably from DBMS to DBMS.

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

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

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

The Oracle DBMS supports the SQL BEFORE trigger.

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

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

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

What are SQL triggers and how are they used?

The SQL command ________ is used to create a virtual table.

The SQL statement ________ is used to delete a view from a database.

SQL views are used for all except ________.

Unlike typical subqueries,correlated subqueries creates "copies" of a table,and evaluate each row of the outer copy with every row of the inner copy.

SQL views can be used to hide columns.

Outer joins are completely supported in Microsoft Access.

SQL views can be used to hide table ________.

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

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

How are SQL views handled in Microsoft Access?

The SQL MERGE statement is,effectively,the combination of the SQL INSERT and SQL UPDATE statements.

Importing Microsoft Excel data into a DMBS varies considerably from DBMS to DBMS.

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

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

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

The Oracle DBMS supports the SQL BEFORE trigger.

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

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

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

What are SQL triggers and how are they used?

The SQL command ________ is used to create a virtual table.

The SQL statement ________ is used to delete a view from a database.

SQL views are used for all except ________.

Unlike typical subqueries,correlated subqueries creates "copies" of a table,and evaluate each row of the outer copy with every row of the inner copy.

SQL views can be used to hide columns.

Outer joins are completely supported in Microsoft Access.

SQL views can be used to hide table ________.

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