Question 1

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

Accepted Answer

transactions

Question 2

RDBMSs store database definition information in system-created tables which can be considered a data dictionary.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

two

Question 4

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 5

A correlated subquery is executed once for each iteration through the outer loop.

Accepted Answer

A) True 
 B)False

Question 6

What strategies can be used to write queries that run more efficiently?

Accepted Answer

It makes sense to specify the attribute

Question 7

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

Accepted Answer

The answer of Using an ________ produces this information: rows...

Question 8

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

The answer of A ________ is the same as an...

Question 9

SQL statements can be included in another language,such as C or Java.

Accepted Answer

A) True 
 B)False

Question 10

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 11

Specifying the attribute names in the select statement will make it easier to find errors in queries and also correct for problems that may occur in the base system.

Accepted Answer

A) True 
 B)False

Question 12

The natural join is very rarely used.

Accepted Answer

A) True 
 B)False

Question 13

Combining a table with itself results in a faster query.

Accepted Answer

A) True 
 B)False

Question 14

The following queries produce the same results.
select 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 15

It is better not to have a result set identified before writing group by and having clauses for a query.

Accepted Answer

A) True 
 B)False

Question 16

All of the following are part of the coding structure for triggers EXCEPT:

Accepted Answer

A)  event. 
B)  condition. 
C)  selection. 
D)  action. 
A)  event. 
B)  condition. 
C)  selection. 
D)  action.

Question 17

What can be done with persistent stored modules?

Accepted Answer

Persistent stored modules allow one to c

Question 18

A subquery in which processing the inner query depends on data from the outer query is called a codependent query.

Accepted Answer

A) True 
 B)False

Question 19

While triggers do run automatically,________ do not.

Accepted Answer

The answer of While triggers do run automatically,________ do not....

Question 20

The results of a ________ join will be a table that includes all of the data from each table that is joined.

Accepted Answer

The answer of The results of a ________ join will...

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

RDBMSs store database definition information in system-created tables which can be considered a data dictionary.

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

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

A correlated subquery is executed once for each iteration through the outer loop.

What strategies can be used to write queries that run more efficiently?

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

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

SQL statements can be included in another language,such as C or Java.

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.

Specifying the attribute names in the select statement will make it easier to find errors in queries and also correct for problems that may occur in the base system.

The natural join is very rarely used.

Combining a table with itself results in a faster query.

It is better not to have a result set identified before writing group by and having clauses for a query.

All of the following are part of the coding structure for triggers EXCEPT:

What can be done with persistent stored modules?

A subquery in which processing the inner query depends on data from the outer query is called a codependent query.

While triggers do run automatically,________ do not.

The results of a ________ join will be a table that includes all of the data from each table that is joined.

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

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

RDBMSs store database definition information in system-created tables which can be considered a data dictionary.

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

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

A correlated subquery is executed once for each iteration through the outer loop.

What strategies can be used to write queries that run more efficiently?

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

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

SQL statements can be included in another language,such as C or Java.

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.

Specifying the attribute names in the select statement will make it easier to find errors in queries and also correct for problems that may occur in the base system.

The natural join is very rarely used.

Combining a table with itself results in a faster query.

It is better not to have a result set identified before writing group by and having clauses for a query.

All of the following are part of the coding structure for triggers EXCEPT:

What can be done with persistent stored modules?

A subquery in which processing the inner query depends on data from the outer query is called a codependent query.

While triggers do run automatically,________ do not.

The results of a ________ join will be a table that includes all of the data from each table that is joined.

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