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.

Question 2

What are some tips for developing queries?

Accepted Answer

Some suggestions to help the query writi...

Question 3

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 4

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 5

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.

Question 6

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.

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

A procedure is:

Accepted Answer

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

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

Question 11

SQL-invoked routines can be:

Accepted Answer

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

Exam 7: Advanced SQL

SQL-invoked routines can be:

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

One major advantage of the outer join is that:

Correct Answer
verified

A procedure is:

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

What are some tips for developing queries?

Correct Answer
verified
Some suggestions to help the query writi...
View 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 Answer
verified

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

Correct Answer
verified

Exam 7: Advanced SQL

SQL-invoked routines can be:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

One major advantage of the outer join is that:

Correct AnswerverifiedShow Answer

A procedure is:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are some tips for developing queries?

Correct AnswerverifiedSome suggestions to help the query writi...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

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified