Question 1

Joining tables or using a subquery may produce the same result.

Accepted Answer

A) True 
 B)False

Question 2

The following SQL statement is an example of a correlated subquery:
select first_name,last_name,total_sales
from salesman s1
where total_sales > all
(select total_sales from salesman s2
where s1.salesman_id != s2.salesman_id);

Accepted Answer

A) True 
 B)False

Question 3

When a subquery is used in the FROM clause,it is called a(n)________.

Accepted Answer

The answer of When a subquery is used in the...

Question 4

In order to embed SQL inside of another language,the ________ statement must be placed before the SQL in the host language.

Accepted Answer

A)  GET SQL 
B)  EXEC SQL 
C)  RUN SQL 
D)  SQL SQL 
A)  GET SQL 
B)  EXEC SQL 
C)  RUN SQL 
D)  SQL SQL

Question 5

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

Accepted Answer

Both a natural join and an equi-join cre

Question 6

________ 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

Persistent

Question 7

A ________ is a temporary table used in the FROM clause of an SQL query.

Accepted Answer

A)  correlated subquery 
B)  derived table 
C)  view table 
D)  none of the above 
A)  correlated subquery 
B)  derived table 
C)  view table 
D)  none of the above

Question 8

A join operation:

Accepted Answer

A)  brings together data from two different fields. 
B)  causes two tables with a common domain to be combined into a single table or view. 
C)  causes two disparate tables to be combined into a single table or view. 
D)  is used to combine indexing operations. 
A)  brings together data from two different fields. 
B)  causes two tables with a common domain to be combined into a single table or view. 
C)  causes two disparate tables to be combined into a single table or view. 
D)  is used to combine indexing operations.

Question 9

________ consists of hard-coded SQL statements within another language,such as Java or C.

Accepted Answer

The answer of ________ consists of hard-coded SQL statements within...

Question 10

Discuss some of the SQL:200n enhancements and extensions to SQL

Accepted Answer

Several built-in functions were added in

Question 11

In SQL,a(n)________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.

Accepted Answer

A)  correlated 
B)  paired 
C)  natural 
D)  inner 
A)  correlated 
B)  paired 
C)  natural 
D)  inner

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The ________ clause is used to combine the output from multiple queries into a single result table.

Accepted Answer

The answer of The ________ clause is used to combine...

Question 14

The MERGE command:

Accepted Answer

A)  allows one to combine the INSERT and UPDATE operations. 
B)  allows one to combine the INSERT and DELETE operations. 
C)  joins 2 tables together. 
D)  none of the above. 
A)  allows one to combine the INSERT and UPDATE operations. 
B)  allows one to combine the INSERT and DELETE operations. 
C)  joins 2 tables together. 
D)  none of the above.

Question 15

A ________ is a stored subroutine that returns only one value and has only input parameters.

Accepted Answer

The answer of A ________ is a stored subroutine that...

Question 16

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

Accepted Answer

The answer of EXISTS will take a value of ________...

Question 17

________ takes a value of true if a subquery returns an intermediate results table which contains one or more rows.

Accepted Answer

A)  In 
B)  Having 
C)  Exists 
D)  Extents 
A)  In 
B)  Having 
C)  Exists 
D)  Extents

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

What is the difference between a trigger and a routine?

Accepted Answer

A trigger,once written and compiled,sits

Question 20

________ use the result of the outer query to determine the processing of the inner query.

Accepted Answer

Correlated

Joining tables or using a subquery may produce the same result.

The following SQL statement is an example of a correlated subquery: select first_name,last_name,total_sales from salesman s1 where total_sales > all (select total_sales from salesman s2 where s1.salesman_id != s2.salesman_id);

When a subquery is used in the FROM clause,it is called a(n)________.

In order to embed SQL inside of another language,the ________ statement must be placed before the SQL in the host language.

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

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

A ________ is a temporary table used in the FROM clause of an SQL query.

A join operation:

________ consists of hard-coded SQL statements within another language,such as Java or C.

Discuss some of the SQL:200n enhancements and extensions to SQL

In SQL,a(n)________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.

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

The ________ clause is used to combine the output from multiple queries into a single result table.

The MERGE command:

A ________ is a stored subroutine that returns only one value and has only input parameters.

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

________ takes a value of true if a subquery returns an intermediate results table which contains one or more rows.

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

What is the difference between a trigger and a routine?

________ use the result of the outer query to determine the processing of the inner query.

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

Joining tables or using a subquery may produce the same result.

The following SQL statement is an example of a correlated subquery: select first_name,last_name,total_sales from salesman s1 where total_sales > all (select total_sales from salesman s2 where s1.salesman_id != s2.salesman_id);

When a subquery is used in the FROM clause,it is called a(n)________.

In order to embed SQL inside of another language,the ________ statement must be placed before the SQL in the host language.

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

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

A ________ is a temporary table used in the FROM clause of an SQL query.

A join operation:

________ consists of hard-coded SQL statements within another language,such as Java or C.

Discuss some of the SQL:200n enhancements and extensions to SQL

In SQL,a(n)________ subquery is a type of subquery in which processing the inner query depends on data from the outer query.

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

The ________ clause is used to combine the output from multiple queries into a single result table.

The MERGE command:

A ________ is a stored subroutine that returns only one value and has only input parameters.

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

________ takes a value of true if a subquery returns an intermediate results table which contains one or more rows.

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

What is the difference between a trigger and a routine?

________ use the result of the outer query to determine the processing of the inner query.

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