Question 1

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

Question 2

While triggers run automatically, ________ do not and have to be called.

Accepted Answer

A)  trapdoors 
B)  routines 
C)  selects 
D)  updates 
A)  trapdoors 
B)  routines 
C)  selects 
D)  updates B

Question 3

A base table is the underlying table that is used to create views.

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

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 6

The following statement is an example of: 
CREATE TABLE Customer_t (
CustNmbr number(11,0),
CreditLimit number(6,2),
CustStart date,
CustEnd date,
PERIOD for Custperiod(CustStart,CustEnd));

Accepted Answer

A)  a materialized view. 
B)  an application time period table. 
C)  a system-versioned table. 
D)  a dynamic view. 
A)  a materialized view. 
B)  an application time period table. 
C)  a system-versioned table. 
D)  a dynamic view.

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Subqueries can only be used in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 9

In order for two queries to be UNION-compatible, they must:

Accepted Answer

A)  both have the same number of lines in their SQL statements. 
B)  both output compatible data types for each column and return the same number of rows. 
C)  both return at least one row. 
D)  both return exactly one row. 
A)  both have the same number of lines in their SQL statements. 
B)  both output compatible data types for each column and return the same number of rows. 
C)  both return at least one row. 
D)  both return exactly one row.

Question 10

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

Accepted Answer

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

Question 11

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 12

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 13

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 14

When is it better to use a subquery over using a join?

Accepted Answer

Often, a subquery and join will return t

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

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

What are some tips for developing queries?

Accepted Answer

Some suggestions to help the query writi

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

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

While triggers run automatically, ________ do not and have to be called.

A base table is the underlying table that is used to create views.

A procedure is:

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 following statement is an example of: CREATE TABLE Customer_t ( CustNmbr number(11,0), CreditLimit number(6,2), CustStart date, CustEnd date, PERIOD for Custperiod(CustStart,CustEnd));

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

Subqueries can only be used in the WHERE clause.

In order for two queries to be UNION-compatible, they must:

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

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

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

It is better not to have a result set identified before writing GROUP BY and HAVING clauses for a query.

When is it better to use a subquery over using a join?

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

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

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

What are some tips for developing queries?

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):

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 6: Advanced SQL

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

While triggers run automatically, ________ do not and have to be called.

A base table is the underlying table that is used to create views.

A procedure is:

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 following statement is an example of: CREATE TABLE Customer_t ( CustNmbr number(11,0), CreditLimit number(6,2), CustStart date, CustEnd date, PERIOD for Custperiod(CustStart,CustEnd));

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

Subqueries can only be used in the WHERE clause.

In order for two queries to be UNION-compatible, they must:

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

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

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

It is better not to have a result set identified before writing GROUP BY and HAVING clauses for a query.

When is it better to use a subquery over using a join?

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

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

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

What are some tips for developing queries?

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):

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Introduction to SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters