Question 1

To relate two tables, in the FROM clause list all columns involved in the query.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

product
Ca

Question 3

For two tables to be union compatible, the columns of the two tables must be identical.

Accepted Answer

A) True 
 B)False

Question 4

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 5

To retrieve data from more than one table, you must ____________________ the tables together by finding rows in the two tables that have identical values in matching columns.

Accepted Answer

The answer of To retrieve data from more than one...

Question 6

A subquery within a subquery is called a(n) ____________________ subquery.

Accepted Answer

The answer of A subquery within a subquery is called...

Question 7

Joining a table to itself is called a(n) ____________________.

Accepted Answer

The answer of Joining a table to itself is called...

Question 8

In a nested query, the outer query is evaluated first.

Accepted Answer

A) True 
 B)False

Question 9

One reason for using an alias is simplicity.

Accepted Answer

A) True 
 B)False

Question 10

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 11

To produce the same results as the MINUS operator, use NOT, the IN operator and a subquery.

Accepted Answer

A) True 
 B)False

Question 12

To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.

Accepted Answer

A)  AND 
B)  IN 
C)  OR 
D)  NOT 
A)  AND 
B)  IN 
C)  OR 
D)  NOT

Question 13

What steps should you take to construct the SQL command to join (relate) tables?

Accepted Answer

1. In the SELECT clause, list all column

Question 14

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 15

The ____________________ of two tables is a table containing all rows that are in both tables.

Accepted Answer

intersecti

To relate two tables, in the FROM clause list all columns involved in the query.

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

For two tables to be union compatible, the columns of the two tables must be identical.

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.

To retrieve data from more than one table, you must ____________________ the tables together by finding rows in the two tables that have identical values in matching columns.

A subquery within a subquery is called a(n) ____________________ subquery.

Joining a table to itself is called a(n) ____________________.

In a nested query, the outer query is evaluated first.

One reason for using an alias is simplicity.

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

To produce the same results as the MINUS operator, use NOT, the IN operator and a subquery.

To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.

What steps should you take to construct the SQL command to join (relate) tables?

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

The ____________________ of two tables is a table containing all rows that are in both tables.

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

Database Design Fundamentals

Creating Tables

Single-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Exam 5: Multiple-Table Queries

To relate two tables, in the FROM clause list all columns involved in the query.

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

For two tables to be union compatible, the columns of the two tables must be identical.

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.

To retrieve data from more than one table, you must ____________________ the tables together by finding rows in the two tables that have identical values in matching columns.

A subquery within a subquery is called a(n) ____________________ subquery.

Joining a table to itself is called a(n) ____________________.

In a nested query, the outer query is evaluated first.

One reason for using an alias is simplicity.

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

To produce the same results as the MINUS operator, use NOT, the IN operator and a subquery.

To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.

What steps should you take to construct the SQL command to join (relate) tables?

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

The ____________________ of two tables is a table containing all rows that are in both tables.

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

Database Design Fundamentals

Creating Tables

Single-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters