Question 1

An SQL query that implements an outer join will return rows that do not have matching values in common columns.

Accepted Answer

A) True 
 B)False

Question 2

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

Accepted Answer

A)  natural join. 
B)  equi-join. 
C)  outer join. 
D)  union join. 
A)  natural join. 
B)  equi-join. 
C)  outer join. 
D)  union join.

Question 3

A procedure is:

Accepted Answer

A)  stored within the database. 
B)  given a unique name. 
C)  called by name. 
D)  all of the above. 
A)  stored within the database. 
B)  given a unique name. 
C)  called by name. 
D)  all of the above.

Question 4

SQL provides the ________ technique,which involves placing an inner query within the where or having clause of an outer query.

Accepted Answer

The answer of SQL provides the ________ technique,which involves placing...

Question 5

SQL-invoked routines can be:

Accepted Answer

A)  procedures. 
B)  functions. 
C)  all of the above. 
D)  none of the above. 
A)  procedures. 
B)  functions. 
C)  all of the above. 
D)  none of the above.

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

A named set of SQL statements that are considered when a data modification occurs are called:

Accepted Answer

A)  stored procedures. 
B)  treatments. 
C)  triggers. 
D)  trapdoors. 
A)  stored procedures. 
B)  treatments. 
C)  triggers. 
D)  trapdoors.

Question 8

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)  all of the above. 
A)  information is easily accessible. 
B)  information is not lost. 
C)  the query is easier to write. 
D)  all of the above.

Question 9

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 10

What results would the following SQL statement produce?
Select owner,table_name
From dba_tables
Where table_name = 'CUSTOMER';

Accepted Answer

A)  A listing of all customers in the customer table 
B)  A listing of the owner of the customer table 
C)  A listing of the owner of the customer table as well as customers 
D)  An error message 
A)  A listing of all customers in the customer table 
B)  A listing of the owner of the customer table 
C)  A listing of the owner of the customer table as well as customers 
D)  An error message

Question 11

What are some tips for developing queries?

Accepted Answer

Some suggestions to help the query writi

An SQL query that implements an outer join will return rows that do not have matching values in common columns.

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

A procedure is:

SQL provides the ________ technique,which involves placing an inner query within the where or having clause of an outer query.

SQL-invoked routines can be:

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

A named set of SQL statements that are considered when a data modification occurs are called:

One major advantage of the outer join is that:

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

What results would the following SQL statement produce? Select owner,table_name From dba_tables Where table_name = 'CUSTOMER';

What are some tips for developing queries?

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 SQL query that implements an outer join will return rows that do not have matching values in common columns.

A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):

A procedure is:

SQL provides the ________ technique,which involves placing an inner query within the where or having clause of an outer query.

SQL-invoked routines can be:

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

A named set of SQL statements that are considered when a data modification occurs are called:

One major advantage of the outer join is that:

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

What results would the following SQL statement produce? Select owner,table_name From dba_tables Where table_name = 'CUSTOMER';

What are some tips for developing queries?

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