Question 1

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

A)  union 
B)  intersect 
C)  intersection 
D)  difference 
A)  union 
B)  intersect 
C)  intersection 
D)  difference

Question 2

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 3

When joining tables, it is always necessary to qualify a column name.

Accepted Answer

A) True 
 B)False

Question 4

You join tables in SQL by including a condition in the ____________________ clause to ensure that matching columns contain equal values.

Accepted Answer

The answer of You join tables in SQL by including...

Question 5

You can use the EXISTS operator to retrieve data from more than one table.

Accepted Answer

A) True 
 B)False

Question 6

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 7

A(n) ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group.

Accepted Answer

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

Question 8

There are three types of inner joins.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

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

Question 12

There are three set operations: union, intersection, difference. Define each of these operations. Which are supported by Oracle?

Accepted Answer

The union of two tables creates a tempor

Question 13

Why do you use the ANY and ALL operators? What is the difference between the two operators?

Accepted Answer

You can use the ALL and ANY operators wi

Question 14

Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.

Accepted Answer

A)  union 
B)  minus 
C)  difference 
D)  intersect 
A)  union 
B)  minus 
C)  difference 
D)  intersect

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

Oracle supports the INTERSECT operator.

Accepted Answer

A) True 
 B)False

Question 18

To produce the same results as the INTERSECT operator, use the BETWEEN operator and a subquery.

Accepted Answer

A) True 
 B)False

Question 19

SQL Server does not support the MINUS operator.

Accepted Answer

A) True 
 B)False

Question 20

You can join three tables together but not four tables.

Accepted Answer

A) True 
 B)False

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.

When joining tables, it is always necessary to qualify a column name.

You join tables in SQL by including a condition in the ____________________ clause to ensure that matching columns contain equal values.

You can use the EXISTS operator to retrieve data from more than one table.

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

A(n) ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group.

There are three types of inner joins.

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

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?

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

There are three set operations: union, intersection, difference. Define each of these operations. Which are supported by Oracle?

Why do you use the ANY and ALL operators? What is the difference between the two operators?

Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.

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

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

Oracle supports the INTERSECT operator.

To produce the same results as the INTERSECT operator, use the BETWEEN operator and a subquery.

SQL Server does not support the MINUS operator.

You can join three tables together but not four 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

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.

When joining tables, it is always necessary to qualify a column name.

You join tables in SQL by including a condition in the ____________________ clause to ensure that matching columns contain equal values.

You can use the EXISTS operator to retrieve data from more than one table.

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

A(n) ____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group.

There are three types of inner joins.

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

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?

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

There are three set operations: union, intersection, difference. Define each of these operations. Which are supported by Oracle?

Why do you use the ANY and ALL operators? What is the difference between the two operators?

Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.

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

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

Oracle supports the INTERSECT operator.

To produce the same results as the INTERSECT operator, use the BETWEEN operator and a subquery.

SQL Server does not support the MINUS operator.

You can join three tables together but not four 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