Question 1

Triggers have three parts: the event, the condition, and the action.

Accepted Answer

A) True 
 B)False

Question 2

What would the following view contain for values? 
Create view CustomerOrders as
Select CustID, Count(*) as TotOrders, Sum(ordertotal) as Value
From customer inner join sale on customer.customer_id = sale.customer_id;

Accepted Answer

A)  A listing of all customers in the customer table 
B)  A listing of the customer ID as well as the total number of orders and the total amount spent by the customer 
C)  A listing of the customer ID as well as the total orders 
D)  An error message 
A)  A listing of all customers in the customer table 
B)  A listing of the customer ID as well as the total number of orders and the total amount spent by the customer 
C)  A listing of the customer ID as well as the total orders 
D)  An error message

Question 3

When a user creates a virtual table it is called a(n):

Accepted Answer

A)  materialized view. 
B)  virtual table. 
C)  inline view. 
D)  dynamic view. 
A)  materialized view. 
B)  virtual table. 
C)  inline view. 
D)  dynamic view.

Question 4

The joining condition of an equi-join is based upon an equality.

Accepted Answer

A) True 
 B)False

Question 5

The following queries produce the same results.
SELECT DISTINCT Customer_Name, Customer_City
FROM Customer, Salesman
WHERE Customer.Salesman_ID = Salesman.Salesman_ID
and Salesman.Lname = 'SMITH';

SELECT Customer_Name, Customer_City
FROM Customer
WHERE Customer.Salesman_ID =
(SELECT Salesman_ID
FROM Salesman
WHERE Lname = 'SMITH');

Accepted Answer

A) True 
 B)False

Question 6

The following code would include: 
SELECT Customer_T.CustomerID,CustomerName, OrderID
FROM Customer_T LEFT OUTER JOIN Order_T ON
Customer_T.CustomerID = Order_T.CustomerID;

Accepted Answer

A)  all rows of the Order_T Table regardless of matches with the Customer_T Table. 
B)  all rows of the Customer_T Table regardless of matches with the Order_T Table. 
C)  only rows that match both Customer_T and Order_T Tables. 
D)  only rows that don't match both Customer_T and Order_T Tables. 
A)  all rows of the Order_T Table regardless of matches with the Customer_T Table. 
B)  all rows of the Customer_T Table regardless of matches with the Order_T Table. 
C)  only rows that match both Customer_T and Order_T Tables. 
D)  only rows that don't match both Customer_T and Order_T Tables.

Question 7

A natural join is the same as an equi-join, except that it is performed over matching columns that have been defined with the same name, and one of the duplicate columns is eliminated.

Accepted Answer

A) True 
 B)False

Question 8

Discuss the differences between an equi-join, natural join, and outer join.

Accepted Answer

Both a natural join and an equi-join cre

Question 9

IF-THEN-ELSE logical processing cannot be accomplished within an SQL statement.

Accepted Answer

A) True 
 B)False

Question 10

Constraints are a special case of triggers.

Accepted Answer

A) True 
 B)False

Question 11

The following code would include: 
SELECT Customer_T.CustomerID, Order_T.CustomerID,
CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;

Accepted Answer

A)  all rows of the Order_T Table regardless of matches with the Customer_T Table. 
B)  all rows of the Customer_T Table regardless of matches with the Order_T Table. 
C)  only rows that match both Customer_T and Order_T Tables. 
D)  only rows that don't match both Customer_T and Order_T Tables. 
A)  all rows of the Order_T Table regardless of matches with the Customer_T Table. 
B)  all rows of the Customer_T Table regardless of matches with the Order_T Table. 
C)  only rows that match both Customer_T and Order_T Tables. 
D)  only rows that don't match both Customer_T and Order_T Tables.

Question 12

A type of query that is placed within a WHERE or HAVING clause of another query is called a:

Accepted Answer

A)  master query. 
B)  subquery. 
C)  superquery. 
D)  multi-query. 
A)  master query. 
B)  subquery. 
C)  superquery. 
D)  multi-query.

Question 13

EXISTS takes a value of false if the subquery returns an intermediate result set.

Accepted Answer

A) True 
 B)False

Question 14

User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead.

Accepted Answer

A) True 
 B)False

Question 15

The following code is an example of a Subquery.
SELECT Customer_T.CustomerID, Order_T.CustomerID,
CustomerName, OrderID
FROM Customer_T, Order_T
WHERE Customer_T.CustomerID = Order_T. CustomerID;

Accepted Answer

A) True 
 B)False

Question 16

Using an outer join produces this information: rows that do not have matching values in common columns are not included in the result table.

Accepted Answer

A) True 
 B)False

Question 17

The following code is an example of a: 
SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,
CustomerPostalCode
FROM Customer_T
WHERE Customer_T.CustomerID =
(SELECT Order_T.CustomerID
FROM Order_T
WHERE OrderID = 1008);

Accepted Answer

A)  correlated subquery. 
B)  subquery. 
C)  join. 
D)  FULL OUTER JOIN. 
A)  correlated subquery. 
B)  subquery. 
C)  join. 
D)  FULL OUTER JOIN.

Question 18

A trigger is a named set of SQL statements that are considered when a data modification occurs.

Accepted Answer

A) True 
 B)False

Question 19

The natural join is very rarely used.

Accepted Answer

A) True 
 B)False

Question 20

A type of join between three tables is called a(n):

Accepted Answer

A)  ternary join. 
B)  self-join. 
C)  unnatural join. 
D)  pinned join. 
A)  ternary join. 
B)  self-join. 
C)  unnatural join. 
D)  pinned join.

Triggers have three parts: the event, the condition, and the action.

What would the following view contain for values? Create view CustomerOrders as Select CustID, Count(*) as TotOrders, Sum(ordertotal) as Value From customer inner join sale on customer.customer_id = sale.customer_id;

When a user creates a virtual table it is called a(n):

The joining condition of an equi-join is based upon an equality.

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T LEFT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;

A natural join is the same as an equi-join, except that it is performed over matching columns that have been defined with the same name, and one of the duplicate columns is eliminated.

Discuss the differences between an equi-join, natural join, and outer join.

IF-THEN-ELSE logical processing cannot be accomplished within an SQL statement.

Constraints are a special case of triggers.

The following code would include: SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID;

A type of query that is placed within a WHERE or HAVING clause of another query is called a:

EXISTS takes a value of false if the subquery returns an intermediate result set.

User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead.

The following code is an example of a Subquery. SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID;

Using an outer join produces this information: rows that do not have matching values in common columns are not included in the result table.

The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderID = 1008);

A trigger is a named set of SQL statements that are considered when a data modification occurs.

The natural join is very rarely used.

A type of join between three tables is called a(n):

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 6: Advanced SQL

Triggers have three parts: the event, the condition, and the action.

What would the following view contain for values? Create view CustomerOrders as Select CustID, Count(*) as TotOrders, Sum(ordertotal) as Value From customer inner join sale on customer.customer_id = sale.customer_id;

When a user creates a virtual table it is called a(n):

The joining condition of an equi-join is based upon an equality.

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T LEFT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;

A natural join is the same as an equi-join, except that it is performed over matching columns that have been defined with the same name, and one of the duplicate columns is eliminated.

Discuss the differences between an equi-join, natural join, and outer join.

IF-THEN-ELSE logical processing cannot be accomplished within an SQL statement.

Constraints are a special case of triggers.

The following code would include: SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID;

A type of query that is placed within a WHERE or HAVING clause of another query is called a:

EXISTS takes a value of false if the subquery returns an intermediate result set.

User-defined functions can improve system performance because they will be processed as sets rather than individually, thus reducing system overhead.

The following code is an example of a Subquery. SELECT Customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID = Order_T. CustomerID;

Using an outer join produces this information: rows that do not have matching values in common columns are not included in the result table.

The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState, CustomerPostalCode FROM Customer_T WHERE Customer_T.CustomerID = (SELECT Order_T.CustomerID FROM Order_T WHERE OrderID = 1008);

A trigger is a named set of SQL statements that are considered when a data modification occurs.

The natural join is very rarely used.

A type of join between three tables is called a(n):

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters