Question 1

It is easy to create a product inadvertently by omitting the WHERE clause when you are attempting to join tables.

Accepted Answer

A) True 
 B)False  True

Question 2

You must join tables by finding rows in the two tables that have identical values in matching columns.

Accepted Answer

A) True 
 B)False  True

Question 3

The ____________________ of two tables is the combination of all rows in the first table and all rows in the second table.​

Accepted Answer

product
Cartesian Product​

Question 4

A join that compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause is called a(n)____________________ join.​

Accepted Answer

The answer of A join that compares the tables in...

Question 5

To ensure that query results are listed in a desired order,use the ORDER BY clause.

Accepted Answer

A) True 
 B)False

Question 6

You can perform special operations,such as self-joins,within SQL.

Accepted Answer

A) True 
 B)False

Question 7

The product operation is commonly used.

Accepted Answer

A) True 
 B)False

Question 8

The ____ of two tables is a table containing every row that is in either the first table,the second table,or both tables.​

Accepted Answer

A) intersection 
B) ​union 
C) minus 
D) ​difference 
A) intersection 
B) ​union 
C) minus 
D) ​difference

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

The ____________________ of two tables is the set of all rows that are in the first table but that are not in the second table.​

Accepted Answer

The answer of The ____________________ of two tables is the...

Question 11

If you had two separate tables for customers and the query requested customers in the first table having the same city as customers in the second table,you could use a normal ____________________ operation to find the answer.​

Accepted Answer

The answer of If you had two separate tables for...

Question 12

If you precede the subquery by the ____ operator,the condition is true only if it satisfies all values produced by the subquery.​

Accepted Answer

A) TRUE 
B) ​ALL 
C) IS ALL 
D) ​ALWAYS 
A) TRUE 
B) ​ALL 
C) IS ALL 
D) ​ALWAYS

Question 13

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

Accepted Answer

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

Question 14

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?​

Accepted Answer

A) inner 
B) ​outer 
C) nested 
D) ​product 
A) inner 
B) ​outer 
C) nested 
D) ​product

Question 15

You create an alias by typing the name of the table,pressing the ____,and then typing the name of the alias.​

Accepted Answer

A) Tab 
B) ​Backspace 
C) Enter 
D) ​Spacebar 
A) Tab 
B) ​Backspace 
C) Enter 
D) ​Spacebar

Question 16

In a ____,all rows from the table on the left (the table listed first in the query)will be included regardless of whether they match rows from the table on the right (the table listed second in the query).​

Accepted Answer

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

Question 17

When there is potential ambiguity in listing column names,you must ____________________ the columns involved in the query.​

Accepted Answer

The answer of When there is potential ambiguity in listing...

Question 18

You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed.​

Accepted Answer

A) IS NULL 
B) ​IS TRUE 
C) IS EXIST 
D) ​EXISTS 
A) IS NULL 
B) ​IS TRUE 
C) IS EXIST 
D) ​EXISTS

Question 19

You must use a comma or a period to separate a table name from its alias.

Accepted Answer

A) True 
 B)False

Question 20

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 the...

It is easy to create a product inadvertently by omitting the WHERE clause when you are attempting to join tables.

You must join tables by finding rows in the two tables that have identical values in matching columns.

The ____________________ of two tables is the combination of all rows in the first table and all rows in the second table.

A join that compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause is called a(n)____________________ join.

To ensure that query results are listed in a desired order,use the ORDER BY clause.

You can perform special operations,such as self-joins,within SQL.

The product operation is commonly used.

The ____ of two tables is a table containing every row that is in either the first table,the second table,or both tables.

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

The ____________________ of two tables is the set of all rows that are in the first table but that are not in the second table.

If you had two separate tables for customers and the query requested customers in the first table having the same city as customers in the second table,you could use a normal ____________________ operation to find the answer.

If you precede the subquery by the ____ operator,the condition is true only if it satisfies all values produced by the subquery.

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

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?

You create an alias by typing the name of the table,pressing the ____,and then typing the name of the alias.

In a ____,all rows from the table on the left (the table listed first in the query)will be included regardless of whether they match rows from the table on the right (the table listed second in the query).

When there is potential ambiguity in listing column names,you must ____________________ the columns involved in the query.

You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed.

You must use a comma or a period to separate a table name from its alias.

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.

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Single-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Exam 5: Multiple-Table Queries

It is easy to create a product inadvertently by omitting the WHERE clause when you are attempting to join tables.

You must join tables by finding rows in the two tables that have identical values in matching columns.

The ____________________ of two tables is the combination of all rows in the first table and all rows in the second table.​

A join that compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause is called a(n)____________________ join.​

To ensure that query results are listed in a desired order,use the ORDER BY clause.

You can perform special operations,such as self-joins,within SQL.

The product operation is commonly used.

The ____ of two tables is a table containing every row that is in either the first table,the second table,or both tables.​

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

The ____________________ of two tables is the set of all rows that are in the first table but that are not in the second table.​

If you had two separate tables for customers and the query requested customers in the first table having the same city as customers in the second table,you could use a normal ____________________ operation to find the answer.​

If you precede the subquery by the ____ operator,the condition is true only if it satisfies all values produced by the subquery.​

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

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?​

You create an alias by typing the name of the table,pressing the ____,and then typing the name of the alias.​

In a ____,all rows from the table on the left (the table listed first in the query)will be included regardless of whether they match rows from the table on the right (the table listed second in the query).​

When there is potential ambiguity in listing column names,you must ____________________ the columns involved in the query.​

You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed.​

You must use a comma or a period to separate a table name from its alias.

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.​

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Single-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

The ____________________ of two tables is the combination of all rows in the first table and all rows in the second table.

A join that compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause is called a(n)____________________ join.

The ____ of two tables is a table containing every row that is in either the first table,the second table,or both tables.

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

The ____________________ of two tables is the set of all rows that are in the first table but that are not in the second table.

If you had two separate tables for customers and the query requested customers in the first table having the same city as customers in the second table,you could use a normal ____________________ operation to find the answer.

If you precede the subquery by the ____ operator,the condition is true only if it satisfies all values produced by the subquery.

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

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?

You create an alias by typing the name of the table,pressing the ____,and then typing the name of the alias.

In a ____,all rows from the table on the left (the table listed first in the query)will be included regardless of whether they match rows from the table on the right (the table listed second in the query).

When there is potential ambiguity in listing column names,you must ____________________ the columns involved in the query.

You can precede a subquery with the ____ operator to create a condition that is true if one or more rows are obtained when the subquery is executed.

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.