Question 1

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.E) A) and C)
F) B) and C)

Question 2

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.E) A) and D)
F) B) and C)

Question 3

________ 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)   ExtentsE) B) and C)
F) B) and D) C

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

Often, a subquery and join will return t...

Question 7

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.E) B) and D)
F) B) and C)

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A)   trapdoors
B)   routines
C)   selects
D)   updatesE) A) and B)
F) A) and C) B

Question 10

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.E) B) and D)
F) B) and C)

Question 11

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

Accepted Answer

A)   event.
B)   condition.
C)   selection.
D)   action.E) A) and B)
F) A) and C)

Question 12

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

Accepted Answer

A) True 
 B)False  True

Question 13

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.E) B) and C)
F) C) and D)

Question 14

What are some tips for developing queries?

Accepted Answer

Some suggestions to help the query writi...

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)   fiveE) A) and C)
F) All of the above

Question 16

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.E) B) and C)
F) A) and D)

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

Subqueries can only be used in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 6: Advanced SQL

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

Correct AnswerverifiedShow Answer

A procedure is:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedOften, a subquery and join will return t...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA self-join is a join of one table to it...View AnswerShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

What are some tips for developing queries?

Correct AnswerverifiedSome suggestions to help the query writi...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Subqueries can only be used in the WHERE clause.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Often, a subquery and join will return t...
View Answer

Correct Answer
verified

Correct Answer
verified
A self-join is a join of one table to it...
View Answer

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified
Some suggestions to help the query writi...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified