Exam 9: Joining Data From Multiple Tables

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the title of each book in the BOOKS table and the name of its publisher?

(Multiple Choice)

4.9/5

(34)

Question 81

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

(Multiple Choice)

4.9/5

(36)

Question 82

By default, use of the JOIN keyword creates an inner join.

(True/False)

4.9/5

(41)

Question 83

If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows, there will be 13 rows in the results.

(True/False)

4.9/5

(37)

Question 84

A join that is based upon data having equivalent data in common columns is known as a(n) ____________________ join.

(Short Answer)

4.9/5

(30)

Question 85

If a Cartesian join is used to link table A which contains two rows to table B which contains eight rows, there will be sixteen rows in the results.

(True/False)

4.9/5

(30)

Question 86

Tables can be joined in the $\underline {\text { FROM } }$ clause or the WHERE clause of a SELECT statement. _________________________

(True/False)

4.8/5

(40)

Question 87

By default, the $\underline { \text { JOIN } }$ keyword creates an inner join. _________________________

(True/False)

4.8/5

(31)

Question 88

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following SQL statements will list the name of each customer stored in the customers table, and, if the customer has placed an order that is contained in the ORDERS table, the order# of any order each customer has placed?

(Multiple Choice)

4.8/5

(31)

Question 89

A table alias can be assigned in the FROM clause, even when tables are being joined using the NATURAL JOIN keywords.

(True/False)

4.8/5

(27)

Question 90

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?

(Multiple Choice)

4.9/5

(31)

Question 91

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following SQL statements will return the names of all customers who placed an order on April 12, 2003?

(Multiple Choice)

4.7/5

(36)

Question 92

A(n) ____________________ is an alternate name temporarily assigned to a table.

(Short Answer)

4.8/5

(34)

Question 93

A column qualifier is used to indicate the table containing the column being referenced.

(True/False)

5.0/5

(32)

Question 94

If you are joining $\underline {\text { five } }$ tables in a SELECT statement, five joining conditions will be required. _________________________

(True/False)

4.9/5

(33)

Question 95

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

(True/False)

4.8/5

(25)

Question 96

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table, as well as the name of the contact person and the phone number to call to reorder the book?

(Multiple Choice)

4.7/5

(22)

Question 97

If the first table in a Cartesian join has five rows and the second table has three rows, the results will consist of ____________________ rows.

(Short Answer)

4.8/5

(35)

Question 98

The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.

(True/False)

4.8/5

(42)

Question 99

If a table alias is assigned in the $\underline { \text { SELECT } }$ clause, it must be used any time the table is referenced in that SQL statement. _________________________

(True/False)

4.8/5

(42)

Question 100

Showing 81 - 100 of 131

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the title of each book in the BOOKS table and the name of its publisher?

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

By default, use of the JOIN keyword creates an inner join.

If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows, there will be 13 rows in the results.

A join that is based upon data having equivalent data in common columns is known as a(n) ____________________ join.

If a Cartesian join is used to link table A which contains two rows to table B which contains eight rows, there will be sixteen rows in the results.

Tables can be joined in the $\underline {\text { FROM } }$ clause or the WHERE clause of a SELECT statement. _________________________

By default, the $\underline { \text { JOIN } }$ keyword creates an inner join. _________________________

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following SQL statements will list the name of each customer stored in the customers table, and, if the customer has placed an order that is contained in the ORDERS table, the order# of any order each customer has placed?

A table alias can be assigned in the FROM clause, even when tables are being joined using the NATURAL JOIN keywords.

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?

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following SQL statements will return the names of all customers who placed an order on April 12, 2003?

A(n) ____________________ is an alternate name temporarily assigned to a table.

A column qualifier is used to indicate the table containing the column being referenced.

If you are joining $\underline {\text { five } }$ tables in a SELECT statement, five joining conditions will be required. _________________________

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

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table, as well as the name of the contact person and the phone number to call to reorder the book?

If the first table in a Cartesian join has five rows and the second table has three rows, the results will consist of ____________________ rows.

The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.

If a table alias is assigned in the $\underline { \text { SELECT } }$ clause, it must be used any time the table is referenced in that SQL statement. _________________________

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

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the title of each book in the BOOKS table and the name of its publisher?

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

By default, use of the JOIN keyword creates an inner join.

If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows, there will be 13 rows in the results.

A join that is based upon data having equivalent data in common columns is known as a(n) ____________________ join.

If a Cartesian join is used to link table A which contains two rows to table B which contains eight rows, there will be sixteen rows in the results.

Tables can be joined in the FROM ‾\underline {\text { FROM } } FROM ​ clause or the WHERE clause of a SELECT statement. _________________________

By default, the JOIN ‾\underline { \text { JOIN } } JOIN ​ keyword creates an inner join. _________________________

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following SQL statements will list the name of each customer stored in the customers table, and, if the customer has placed an order that is contained in the ORDERS table, the order# of any order each customer has placed?

A table alias can be assigned in the FROM clause, even when tables are being joined using the NATURAL JOIN keywords.

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?

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following SQL statements will return the names of all customers who placed an order on April 12, 2003?

A(n) ____________________ is an alternate name temporarily assigned to a table.

A column qualifier is used to indicate the table containing the column being referenced.

If you are joining five ‾\underline {\text { five } } five ​ tables in a SELECT statement, five joining conditions will be required. _________________________

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

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table, as well as the name of the contact person and the phone number to call to reorder the book?

If the first table in a Cartesian join has five rows and the second table has three rows, the results will consist of ____________________ rows.

The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.

If a table alias is assigned in the SELECT ‾\underline { \text { SELECT } } SELECT ​ clause, it must be used any time the table is referenced in that SQL statement. _________________________

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

Tables can be joined in the $\underline {\text { FROM } }$ clause or the WHERE clause of a SELECT statement. _________________________

By default, the $\underline { \text { JOIN } }$ keyword creates an inner join. _________________________

If you are joining $\underline {\text { five } }$ tables in a SELECT statement, five joining conditions will be required. _________________________

If a table alias is assigned in the $\underline { \text { SELECT } }$ clause, it must be used any time the table is referenced in that SQL statement. _________________________