Question 1

An interactive command that can be used to dynamically control a user session for appropriate integrity measures is:

Accepted Answer

A)  rollback. 
B)  rollforward. 
C)  set autocommit. 
D)  expunge. 
A)  rollback. 
B)  rollforward. 
C)  set autocommit. 
D)  expunge.

Question 2

The UNION clause is used to:

Accepted Answer

A)  combine the output from multiple queries into a single result table. 
B)  join two tables together to form one table. 
C)  find all rows that do not match in two tables. 
D)  none of the above. 
A)  combine the output from multiple queries into a single result table. 
B)  join two tables together to form one table. 
C)  find all rows that do not match in two tables. 
D)  none of the above.

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

What is a derived table? When is it used? Can you describe any situations where you would have to use it over a subquery in the where clause?

Accepted Answer

A derived table can be created by placin

Question 5

What is a self-join and how is it used?

Accepted Answer

A self-join is a join of one table to it

Question 6

All of the following are advantages of SQL-invoked routines EXCEPT:

Accepted Answer

A)  flexibility. 
B)  efficiency. 
C)  sharability. 
D)  security. 
A)  flexibility. 
B)  efficiency. 
C)  sharability. 
D)  security.

Question 7

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, 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, 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 8

A ________ is a collection of SQL statements that are assigned a unique name and stored in the database.

Accepted Answer

The answer of A ________ is a collection of SQL...

Question 9

________ can be thought of as a special case of triggers.

Accepted Answer

The answer of ________ can be thought of as a...

Question 10

The advantages of SQL-invoked routines are flexibility,efficiency,shareability and applicability.

Accepted Answer

A) True 
 B)False

Question 11

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

Accepted Answer

A)  using the if-then-else construct. 
B)  using the immediate if statement. 
C)  using the CASE keyword in a statement. 
D)  using a subquery. 
A)  using the if-then-else construct. 
B)  using the immediate if statement. 
C)  using the CASE keyword in a statement. 
D)  using a subquery.

Question 12

The following query will execute without errors:
select customer.customer_name,salesman.sales_quota
from customer
where customer.salesman_id =
(select salesman_id
where lname = 'SMITH');

Accepted Answer

A) True 
 B)False

Question 13

An operation to join a table to itself is called a ________.

Accepted Answer

The answer of An operation to join a table to...

Question 14

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

Accepted Answer

The answer of A ________ is a named set of...

Question 15

User-defined data types:

Accepted Answer

A)  can be a subclass of a standard type. 
B)  can behave as an object. 
C)  can have defined functions and methods. 
D)  can have all of the above. 
A)  can be a subclass of a standard type. 
B)  can behave as an object. 
C)  can have defined functions and methods. 
D)  can have all of the above.

Question 16

________ is used to generate appropriate SQL code on the fly.

Accepted Answer

The answer of ________ is used to generate appropriate SQL...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Correlated subqueries are less efficient than queries that do not use nesting.

Accepted Answer

A) True 
 B)False

Question 19

________,________,and ________ are three new data types added to SQL:200n.

Accepted Answer

The answer of ________,________,and ________ are three new data types...

Question 20

A type of join implemented in SQL-1999 and by extension SQL-2003 that returns all of the data from each table that is joined is called a(n):

Accepted Answer

A)  outer join. 
B)  inner join. 
C)  union join. 
D)  intersect join. 
A)  outer join. 
B)  inner join. 
C)  union join. 
D)  intersect join.

An interactive command that can be used to dynamically control a user session for appropriate integrity measures is:

The UNION clause is used to:

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

What is a derived table? When is it used? Can you describe any situations where you would have to use it over a subquery in the where clause?

What is a self-join and how is it used?

All of the following are advantages of SQL-invoked routines EXCEPT:

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

A ________ is a collection of SQL statements that are assigned a unique name and stored in the database.

________ can be thought of as a special case of triggers.

The advantages of SQL-invoked routines are flexibility,efficiency,shareability and applicability.

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

The following query will execute without errors: select customer.customer_name,salesman.sales_quota from customer where customer.salesman_id = (select salesman_id where lname = 'SMITH');

An operation to join a table to itself is called a ________.

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

User-defined data types:

________ is used to generate appropriate SQL code on the fly.

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

Correlated subqueries are less efficient than queries that do not use nesting.

,,and are three new data types added to SQL:200n.

A type of join implemented in SQL-1999 and by extension SQL-2003 that returns all of the data from each table that is joined is called a(n):

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 7: Advanced SQL

An interactive command that can be used to dynamically control a user session for appropriate integrity measures is:

The UNION clause is used to:

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

What is a derived table? When is it used? Can you describe any situations where you would have to use it over a subquery in the where clause?

What is a self-join and how is it used?

All of the following are advantages of SQL-invoked routines EXCEPT:

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

A ________ is a collection of SQL statements that are assigned a unique name and stored in the database.

________ can be thought of as a special case of triggers.

The advantages of SQL-invoked routines are flexibility,efficiency,shareability and applicability.

Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by:

The following query will execute without errors: select customer.customer_name,salesman.sales_quota from customer where customer.salesman_id = (select salesman_id where lname = 'SMITH');

An operation to join a table to itself is called a ________.

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

User-defined data types:

________ is used to generate appropriate SQL code on the fly.

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

Correlated subqueries are less efficient than queries that do not use nesting.

________,________,and ________ are three new data types added to SQL:200n.

A type of join implemented in SQL-1999 and by extension SQL-2003 that returns all of the data from each table that is joined is called a(n):

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

,,and are three new data types added to SQL:200n.