Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

The answer of ​When two tables that share more than...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of Using the JOIN...____________________ keywords to join two...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

The answer of A table alias can have a maximum...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

The answer of A(n)____________________ join is required when a table...

Question 12

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

Accepted Answer

The answer of A(n)____________________ is an alternate name temporarily assigned...

Question 13

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

Accepted Answer

A)  ​UNION 
B)  ​UNION ALL 
C)  ​INTERSECT 
D)  ​MINUS 
A)  ​UNION 
B)  ​UNION ALL 
C)  ​INTERSECT 
D)  ​MINUS

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)  ​inequality join 
B)  ​outer join 
C)  ​equality join 
D)  ​all of the above 
A)  ​inequality join 
B)  ​outer join 
C)  ​equality join 
D)  ​all of the above

Question 16

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

Accepted Answer

The answer of The outer join operator can only be...

Question 17

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

Accepted Answer

The answer of If the first table in a Cartesian...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

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.

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

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.

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

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

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

A table alias can have a maximum of ____________________ characters.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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.

Set operators are used to combine the results of multiple 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._________________________

A table alias can have a maximum of ____________________ characters.

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

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

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

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

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

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

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

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