True or false: Data stored in multiple tables can be combined through the use of

Question

True or false:

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

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

_____ 3.   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.

____    4.   A Cartesian join usually results from the user omitting the joining condition that links two or more tables together.

____    5.   A column qualifier is separated from the column name with a colon.

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

____    7.   A table alias is assigned to a table in the WHERE clause.

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

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

____ 10.   Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.

_____ 11.   The NATURAL JOIN keywords can be used to create non-equality joins.

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

____ 13.   An outer join operator can be included in a FROM clause to list all rows from one table that do not have a corresponding row in the other table.

____ 14.   The outer join operator is placed on the side of the comparison that is deficient or is missing the matching rows.

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

Explanation / Answer

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

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

_FALSE_    3.   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_      4.   A Cartesian join usually results from the user omitting the joining condition that links two or more tables together.

_FALSE_         5.   A column qualifier is separated from the column name with a colon.

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

_FALSE_         7.   A table alias is assigned to a table in the WHERE clause.

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

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

_TRUE    10.   Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.

_FALSE_         11.   The NATURAL JOIN keywords can be used to create non-equality joins.

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

_TRUE_      13.   An outer join operator can be included in a FROM clause to list all rows from one table that do not have a corresponding row in the other table.

_TRUE_        14.   The outer join operator is placed on the side of the comparison that is deficient or is missing the matching rows.

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

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.