Question 1

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

Accepted Answer

The union of two tables creates a temporary table containing every row that is in either the first table, the second table, or both tables. The intersection of two tables creates a temporary table containing all rows that are in both tables. the difference of two tables creates a temporary table containing the set of all rows that are in the first table but that are not in the second table. MySQL only supports the UNION operator.

Question 2

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

Accepted Answer

A) , 
B) . 
C) % 
D) * 
A) , 
B) . 
C) % 
D) * B

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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.

Accepted Answer

The answer of Sometimes you need to list all the...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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.

Accepted Answer

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

Question 8

MySQL does not support the MINUS operator.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) normal 
B) inner 
C) full outer 
D) combined 
A) normal 
B) inner 
C) full outer 
D) combined

Question 10

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.

Accepted Answer

A) IS SOME 
B) IS ANY 
C) SOME 
D) ANY 
A) IS SOME 
B) IS ANY 
C) SOME 
D) ANY

Question 11

There is only one approach to joining tables.

Accepted Answer

A) True 
 B)False

Question 12

Describe the types of outer joins.

Accepted Answer

There are actually three types of outer

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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.

Accepted Answer

The answer of In a multiple-table query, you list all...

Question 15

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

Accepted Answer

The answer of If the SQL implementation truly supports the...

Question 16

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

Accepted Answer

The answer of When tables are listed in the FROM...

Question 17

You must join tables on matching columns.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) FROM 
B) WHERE 
C) SELECT 
D) JOIN 
A) FROM 
B) WHERE 
C) SELECT 
D) JOIN

Question 19

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

Accepted Answer

The answer of If you precede a subquery by the...

Question 20

One reason for using an alias is simplicity.

Accepted Answer

A) True 
 B)False

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

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

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

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

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.

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

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.

MySQL does not support the MINUS operator.

In a(n)____ join, all rows from both tables are included regardless of whether they match rows from the other 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.

There is only one approach to joining tables.

Describe the types of outer joins.

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

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 the SQL implementation truly supports the union operation, it will remove any duplicate ____________________ automatically.

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

You must join tables on matching columns.

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

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

One reason for using an alias is simplicity.

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

An Introduction to SQL

Single-Table Queries

Updating Data

Database Administration

MySQL Special Topics

Filters

Exam 5: Multiple-Table Queries

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

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

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

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

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.

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

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.

MySQL does not support the MINUS operator.

In a(n)____ join, all rows from both tables are included regardless of whether they match rows from the other 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.

There is only one approach to joining tables.

Describe the types of outer joins.

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

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 the SQL implementation truly supports the union operation, it will remove any duplicate ____________________ automatically.

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

You must join tables on matching columns.

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

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

One reason for using an alias is simplicity.

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

An Introduction to SQL

Single-Table Queries

Updating Data

Database Administration

MySQL Special Topics

Filters