FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Advanced SQL

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 61

Essay

Review LaterAdd Note

Review Later

What are some tips for developing queries?

Correct Answer

verified

Some suggestions to help the query writi...

View Answer

Show Answer

Question 62

Multiple Choice

Review LaterAdd Note

Review Later

One major advantage of the outer join is that:

A) information is easily accessible.
B) information is not lost.
C) the query is easier to write.
D) all of the above.

Correct Answer

verified

Show Answer

Question 63

Multiple Choice

Review LaterAdd Note

A procedure is:

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

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

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

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

SQL-invoked routines can be:

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

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

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