Question 1

What is the difference between a trigger and a routine?

Accepted Answer

A trigger, once written and compiled, si

Question 2

An operation to join a table to itself is called a(n):

Accepted Answer

A)  sufficient-join. 
B)  inner join. 
C)  outer join. 
D)  self-join. 
A)  sufficient-join. 
B)  inner join. 
C)  outer join. 
D)  self-join.

Question 3

One major advantage of the outer join is that:

Accepted Answer

A)  information is easily accessible. 
B)  information is not lost. 
C)  the query is easier to write. 
D)  information's data type changes. 
A)  information is easily accessible. 
B)  information is not lost. 
C)  the query is easier to write. 
D)  information's data type changes.

Question 4

Persistent Sorted Modules are extensions defined in SQL-99 that include the capability to create and drop modules of code stored in the database schema across user sessions.

Accepted Answer

A) True 
 B)False

Question 5

In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier.

Accepted Answer

A) True 
 B)False

Question 6

When a subquery is used in the FROM clause, it is called a denied table.

Accepted Answer

A) True 
 B)False

Question 7

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 8

SQL-invoked routines can be:

Accepted Answer

A)  part of a DDL statement. 
B)  functions or procedures. 
C)  part of a DCL statement. 
D)  contained within a CREATE statement. 
A)  part of a DDL statement. 
B)  functions or procedures. 
C)  part of a DCL statement. 
D)  contained within a CREATE statement.

Question 9

A join in which the joining condition is based on equality between values in the common columns is called a(n):

Accepted Answer

A)  equi-join. 
B)  unilateral join. 
C)  natural join. 
D)  both A and C. 
A)  equi-join. 
B)  unilateral join. 
C)  natural join. 
D)  both A and C.

Question 10

In which of the following situations would one have to use an outer join in order to obtain the desired results?

Accepted Answer

A)  A report is desired that lists all customers who placed an order. 
B)  A report is desired that lists all customers and the total of their orders. 
C)  A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero). 
D)  There is never a situation that requires only an outer join. 
A)  A report is desired that lists all customers who placed an order. 
B)  A report is desired that lists all customers and the total of their orders. 
C)  A report is desired that lists all customers and the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero). 
D)  There is never a situation that requires only an outer join.

Question 11

An equi-join is a join in which one of the duplicate columns is eliminated in the result table.

Accepted Answer

A) True 
 B)False

Question 12

A function has only input parameters but can return multiple values.

Accepted Answer

A) True 
 B)False

Question 13

Establishing IF-THEN-ELSE logical processing within an SQL statement can now be accomplished by using the CASE keyword in a statement.

Accepted Answer

A) True 
 B)False

Question 14

One major disadvantage of the outer join is that information is easily lost.

Accepted Answer

A) True 
 B)False

Question 15

The outer join syntax does not apply easily to a join condition of more than ________ tables.

Accepted Answer

A)  two 
B)  three 
C)  four 
D)  five 
A)  two 
B)  three 
C)  four 
D)  five

Question 16

Persistent Stored Modules are extensions defined in SQL:1999 that include the capability to add and drop modules of code.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

All of the following are guidelines for better query design EXCEPT:

Accepted Answer

A)  understand how indexes are used in query processing. 
B)  use a lot of self-joins. 
C)  write simple queries. 
D)  retrieve only the data that you need. 
A)  understand how indexes are used in query processing. 
B)  use a lot of self-joins. 
C)  write simple queries. 
D)  retrieve only the data that you need.

Question 19

A procedure is:

Accepted Answer

A)  stored outside the database. 
B)  given a reserved SQL name. 
C)  called by name. 
D)  unable to be modified. 
A)  stored outside the database. 
B)  given a reserved SQL name. 
C)  called by name. 
D)  unable to be modified.

Question 20

EXISTS will take a value of ________ if the subquery returns an intermediate results table which contains one or more rows.

Accepted Answer

A)  FALSE 
B)  1 
C)  TRUE 
D)  undefined 
A)  FALSE 
B)  1 
C)  TRUE 
D)  undefined

What is the difference between a trigger and a routine?

An operation to join a table to itself is called a(n):

One major advantage of the outer join is that:

Persistent Sorted Modules are extensions defined in SQL-99 that include the capability to create and drop modules of code stored in the database schema across user sessions.

In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier.

When a subquery is used in the FROM clause, it is called a denied table.

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;

SQL-invoked routines can be:

A join in which the joining condition is based on equality between values in the common columns is called a(n):

In which of the following situations would one have to use an outer join in order to obtain the desired results?

An equi-join is a join in which one of the duplicate columns is eliminated in the result table.

A function has only input parameters but can return multiple values.

Establishing IF-THEN-ELSE logical processing within an SQL statement can now be accomplished by using the CASE keyword in a statement.

One major disadvantage of the outer join is that information is easily lost.

The outer join syntax does not apply easily to a join condition of more than ________ tables.

Persistent Stored Modules are extensions defined in SQL:1999 that include the capability to add and drop modules of code.

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

All of the following are guidelines for better query design EXCEPT:

A procedure is:

EXISTS will take a value of ________ if the subquery returns an intermediate results table which contains one or more rows.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 7: Advanced SQL

What is the difference between a trigger and a routine?

An operation to join a table to itself is called a(n):

One major advantage of the outer join is that:

Persistent Sorted Modules are extensions defined in SQL-99 that include the capability to create and drop modules of code stored in the database schema across user sessions.

In order to find out what customers have not placed an order for a particular item, one might use the NOT qualifier along with the IN qualifier.

When a subquery is used in the FROM clause, it is called a denied table.

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;

SQL-invoked routines can be:

A join in which the joining condition is based on equality between values in the common columns is called a(n):

In which of the following situations would one have to use an outer join in order to obtain the desired results?

An equi-join is a join in which one of the duplicate columns is eliminated in the result table.

A function has only input parameters but can return multiple values.

Establishing IF-THEN-ELSE logical processing within an SQL statement can now be accomplished by using the CASE keyword in a statement.

One major disadvantage of the outer join is that information is easily lost.

The outer join syntax does not apply easily to a join condition of more than ________ tables.

Persistent Stored Modules are extensions defined in SQL:1999 that include the capability to add and drop modules of code.

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

All of the following are guidelines for better query design EXCEPT:

A procedure is:

EXISTS will take a value of ________ if the subquery returns an intermediate results table which contains one or more rows.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters