FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Joining Data From Multiple Tables

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 61

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 62

True/False

Review LaterAdd Note

Review Later

An inequality join refers to a join that is used to link a table to a copy of itself.​

A) True
B) False

Correct Answer

verified

Show Answer

Question 63

Short Answer

Review LaterAdd Note

A table alias can have a maximum of ____________________ characters.​

The number of joining conditions required to join tables is always one less than the number of tables being joined.​

​When two tables that share more than one common column are being joined,the JOIN...____________________ keywords are normally used in the FROM clause to join the tables.

A(n)____________________ join is required when a table must be joined to itself.

Which of the following set operators will display only the unique results of the combined SQL statements?​

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

By default,the JOIN keyword creates an inner join._________________________

​Data stored in multiple tables can be combined through the use of an ORDER BY clause.

The ____________________ set operator is used to display the combined results returned by multiple SELECT statements.

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

Using the JOIN...____________________ keywords to join two tables requires that a condition be specified to indicate how the tables are related.

The UNION set operator will not suppress rows that are returned by both queries.​

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

The outer join operator can only be used in the ____________________ clause.

​A join based upon a column from each table containing equivalent data is known as a(n) ____.

Set operators are used to combine the results of multiple queries.​

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