Question 1

The JOIN keyword is used in the WHERE clause to indicate the tables that should be joined or linked.

Accepted Answer

A) True 
 B)False

Question 2

A self-join can only be specified in the FROM clause with the use of the JOIN...____________________ keywords.

Accepted Answer

The answer of A self-join can only be specified in...

Question 3

​The outer join operator in the WHERE clause cannot be used with which of the following operators?

Accepted Answer

A)  ​IN 
B)  ​OR 
C)  ​AND 
D)  ​both a and b 
A)  ​IN 
B)  ​OR 
C)  ​AND 
D)  ​both a and b

Question 4

Structure of the CUSTOMERS table
   ​
Structure of the ORDERS table
   Structure of the ORDERITEMS table
   Structure of the BOOKS table
-Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?​

Accepted Answer

A)  ​SELECT title
FROM books NATURAL JOIN orderitems
WHERE qty > 1; 
B)  ​SELECT title
FROM books JOIN orderitems
WHERE qty > 1; 
C)  ​SELECT title
FROM books JOIN orderitems ON (isbn)JOIN orders ON (order#)
WHERE qty>1; 
D)  ​SELECT title
FROM books JOIN orderitems USING(isbn); 
A)  ​SELECT title
FROM books NATURAL JOIN orderitems
WHERE qty > 1; 
B)  ​SELECT title
FROM books JOIN orderitems
WHERE qty > 1; 
C)  ​SELECT title
FROM books JOIN orderitems ON (isbn)JOIN orders ON (order#)
WHERE qty>1; 
D)  ​SELECT title
FROM books JOIN orderitems USING(isbn);

Question 5

​The ____________________ set operator is used to display the results that were returned by the first query that were not also returned by the second query.

Accepted Answer

The answer of ​The ____________________ set operator is used to...

Question 6

Equality,non-equality,and self-joins are all categorized as inner joins.​

Accepted Answer

A) True 
 B)False

Question 7

Structure of the CUSTOMERS table
   ​
Structure of the ORDERS table
   Structure of the ORDERITEMS table
   Structure of the BOOKS table
-​To display the name of each customer and the ISBN of each book purchased by the customers would require how many joins in the FROM clause of the SQL statement?

Accepted Answer

A)  ​4 
B)  ​3 
C)  ​2 
D)  ​1 
A)  ​4 
B)  ​3 
C)  ​2 
D)  ​1

Question 8

____________________ operators are used to combine the results of multiple queries.

Accepted Answer

The answer of ____________________ operators are used to combine the...

Question 9

​A(n)____________________ outer join is necessary when you need rows returned from either table that do not have a matching record in the other table.

Accepted Answer

The answer of ​A(n)____________________ outer join is necessary when you...

Question 10

​
Contents of the PROMOTION table
   Structure of the BOOKS table
-Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS?​

Accepted Answer

A)  SELECT gift FROM promotion
WHERE gift = minretail; 
B)  SELECT gift FROM promotion,books
WHERE retail >= minretail AND title = 'SHORTEST POEMS'; 
C)  SELECT gift FROM promotion,books
WHERE retail BETWEEN minretail AND maxretail
AND title = 'SHORTEST POEMS'; 
D)  ​none of the above 
A)  SELECT gift FROM promotion
WHERE gift = minretail; 
B)  SELECT gift FROM promotion,books
WHERE retail >= minretail AND title = 'SHORTEST POEMS'; 
C)  SELECT gift FROM promotion,books
WHERE retail BETWEEN minretail AND maxretail
AND title = 'SHORTEST POEMS'; 
D)  ​none of the above

Question 11

Which of the following is used to create an outer join in a WHERE clause?​

Accepted Answer

A)  ​FULL OUTER JOIN keywords 
B)  ​LEFT OUTER JOIN keywords 
C)  ​RIGHT OUTER JOIN keywords 
D)  ​outer join operator (+) 
A)  ​FULL OUTER JOIN keywords 
B)  ​LEFT OUTER JOIN keywords 
C)  ​RIGHT OUTER JOIN keywords 
D)  ​outer join operator (+)

Question 12

The most common type of join is an equijoin,which joins two or more tables together based upon the tables having equivalent data values in a common column.​

Accepted Answer

A) True 
 B)False

Question 13

Structure of the BOOKS table
   Structure of the PUBLISHER table
-Which of the following SQL statements will display the name of each publisher that publishes a book classified in the COMPUTER category?​

Accepted Answer

A)  SELECT UNIQUE name
FROM books,publisher; 
B)  SELECT UNIQUE name
FROM books NATURAL JOIN publisher
WHERE category = 'COMPUTER'; 
C)  SELECT DISTINCT name
FROM books JOIN publisher
WHERE category = 'COMPUTER'; 
D)  ​both b and c 
A)  SELECT UNIQUE name
FROM books,publisher; 
B)  SELECT UNIQUE name
FROM books NATURAL JOIN publisher
WHERE category = 'COMPUTER'; 
C)  SELECT DISTINCT name
FROM books JOIN publisher
WHERE category = 'COMPUTER'; 
D)  ​both b and c

Question 14

​A full outer join cannot be created in the ____________________ clause.

Accepted Answer

The answer of ​A full outer join cannot be created...

Question 15

​To display rows from one table that do not have a corresponding row in the other table,you must create a(n)____________________ join.

Accepted Answer

The answer of ​To display rows from one table that...

Question 16

An outer join only lists rows that contain a match in both tables.​

Accepted Answer

A) True 
 B)False

Question 17

A table alias is assigned in the FROM clause._________________________​

Accepted Answer

A) True 
 B)False

Question 18

Which of the following types of joins is created by matching equivalent values in each table?​

Accepted Answer

A)  ​Cartesian join 
B)  ​equality join 
C)  ​non-equality join 
D)  ​outer join 
A)  ​Cartesian join 
B)  ​equality join 
C)  ​non-equality join 
D)  ​outer join

Question 19

If you are joining four tables in a SELECT statement,three joining conditions will be required._________________________​

Accepted Answer

A) True 
 B)False

Question 20

A column ____________________ indicates the table containing the column being referenced.​

Accepted Answer

The answer of A column ____________________ indicates the table containing...

The JOIN keyword is used in the WHERE clause to indicate the tables that should be joined or linked.

A self-join can only be specified in the FROM clause with the use of the JOIN...____________________ keywords.

The outer join operator in the WHERE clause cannot be used with which of the following operators?

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?

The ____________________ set operator is used to display the results that were returned by the first query that were not also returned by the second query.

Equality,non-equality,and self-joins are all categorized as inner joins.

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -To display the name of each customer and the ISBN of each book purchased by the customers would require how many joins in the FROM clause of the SQL statement?

____________________ operators are used to combine the results of multiple queries.

A(n)____________________ outer join is necessary when you need rows returned from either table that do not have a matching record in the other table.

Contents of the PROMOTION table Structure of the BOOKS table -Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS?

Which of the following is used to create an outer join in a WHERE clause?

The most common type of join is an equijoin,which joins two or more tables together based upon the tables having equivalent data values in a common column.

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the name of each publisher that publishes a book classified in the COMPUTER category?

A full outer join cannot be created in the ____________________ clause.

To display rows from one table that do not have a corresponding row in the other table,you must create a(n)____________________ join.

An outer join only lists rows that contain a match in both tables.

A table alias is assigned in the FROM clause._________________________

Which of the following types of joins is created by matching equivalent values in each table?

If you are joining four tables in a SELECT statement,three joining conditions will be required._________________________

A column ____________________ indicates the table containing the column being referenced.

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 9: Joining Data From Multiple Tables

The JOIN keyword is used in the WHERE clause to indicate the tables that should be joined or linked.

A self-join can only be specified in the FROM clause with the use of the JOIN...____________________ keywords.

​The outer join operator in the WHERE clause cannot be used with which of the following operators?

Structure of the CUSTOMERS table ​ Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?​

​The ____________________ set operator is used to display the results that were returned by the first query that were not also returned by the second query.

Equality,non-equality,and self-joins are all categorized as inner joins.​

Structure of the CUSTOMERS table ​ Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -​To display the name of each customer and the ISBN of each book purchased by the customers would require how many joins in the FROM clause of the SQL statement?

____________________ operators are used to combine the results of multiple queries.

​A(n)____________________ outer join is necessary when you need rows returned from either table that do not have a matching record in the other table.

​ Contents of the PROMOTION table Structure of the BOOKS table -Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS?​

Which of the following is used to create an outer join in a WHERE clause?​

The most common type of join is an equijoin,which joins two or more tables together based upon the tables having equivalent data values in a common column.​

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the name of each publisher that publishes a book classified in the COMPUTER category?​

​A full outer join cannot be created in the ____________________ clause.

​To display rows from one table that do not have a corresponding row in the other table,you must create a(n)____________________ join.

An outer join only lists rows that contain a match in both tables.​

A table alias is assigned in the FROM clause._________________________​

Which of the following types of joins is created by matching equivalent values in each table?​

If you are joining four tables in a SELECT statement,three joining conditions will be required._________________________​

A column ____________________ indicates the table containing the column being referenced.​

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

The outer join operator in the WHERE clause cannot be used with which of the following operators?

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?

The ____________________ set operator is used to display the results that were returned by the first query that were not also returned by the second query.

Equality,non-equality,and self-joins are all categorized as inner joins.

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -To display the name of each customer and the ISBN of each book purchased by the customers would require how many joins in the FROM clause of the SQL statement?

A(n)____________________ outer join is necessary when you need rows returned from either table that do not have a matching record in the other table.

Contents of the PROMOTION table Structure of the BOOKS table -Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS?

Which of the following is used to create an outer join in a WHERE clause?

The most common type of join is an equijoin,which joins two or more tables together based upon the tables having equivalent data values in a common column.

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the name of each publisher that publishes a book classified in the COMPUTER category?

A full outer join cannot be created in the ____________________ clause.

To display rows from one table that do not have a corresponding row in the other table,you must create a(n)____________________ join.

An outer join only lists rows that contain a match in both tables.

A table alias is assigned in the FROM clause._________________________

Which of the following types of joins is created by matching equivalent values in each table?

If you are joining four tables in a SELECT statement,three joining conditions will be required._________________________

A column ____________________ indicates the table containing the column being referenced.