FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Multiple-Table Queries

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Essay

Review LaterAdd Note

Review Later

Describe the types of outer joins.

Correct Answer

verified

There are actually three types of outer ...

View Answer

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

In a ____, all rows from the table on the right will be included regardless of whether they match rows from the table on the left.

A) left inner join
B) left outer join
C) right outer join
D) right inner join

E) C) and D)
F) A) and D)

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

Sometimes you need to list all the rows from one of the tables in a join, regardless of whether they match any rows in the other table. This type of join is called a(n)____________________ join.

There is only one approach to joining tables.

You can join tables by using a condition in the WHERE clause.

In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table..

You can join tables by using a condition in the ____ clause.

Occasionally, a self-join might involve the primary key of a table.

If the SQL implementation truly supports the union operation, it will remove any duplicate ____________________ automatically.

MySQL does not support the MINUS operator.

In a multiple-table query, you list all the desired columns in the ____________________ clause and qualify any columns that appear in more than one table.

If you precede the subquery by the ____ operator, the condition is true only if it satisfies any value (one or more) produced by the subquery.

To qualify a column name, precede the name of the column with the name of the table, followed by a(n) ____.

When tables are listed in the FROM clause, you can give each table a(n)____________________, or an alternate name.

It is permissible to qualify all column names in a query.

When the innermost subquery is evaluated, a permanent table is produced.

One reason for using an alias is simplicity.

If you precede a subquery by the ____________________ operator, the condition is true only if it satisfies one or more values produced by the subquery.

You must join tables on matching columns.

There are three set operations: union, intersection, difference. Define each of these operations. Which one(s)does MySQL support?