Question 1

A cross join between two tables,containing four rows each,will display eight rows in its output._________________________​

Accepted Answer

A) True 
 B)False

Question 2

A column qualifier indicates the column containing the data being referenced._________________________​

Accepted Answer

A) True 
 B)False

Question 3

A(n)non-equality join is also known as an equijoin,inner join,or simple join._________________________​

Accepted Answer

A) True 
 B)False

Question 4

​The outer join operator is placed on the side of the joining condition that has ____________________ rows.

Accepted Answer

​deficient...

Question 5

​A table alias can consist of a maximum of ____ characters.

Accepted Answer

A)   ​12
B)   ​225
C)   ​255
D)   ​30

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The JOIN keyword is included in which of the following clauses?​

Accepted Answer

A)   ​SELECT
B)   ​FROM
C)   ​WHERE
D)   ​ORDER BY

Question 8

A(n)non-equality join is when a table is joined to itself._________________________​

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ keywords create a join automatically between two tables,based on columns with matching names.

Accepted Answer

The answer of The ____________________ keywords create a join automatically...

Question 10

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?​

Accepted Answer

A)   ​NATURAL JOIN
B)   ​JOIN...ON
C)   ​LEFT OUTER JOIN
D)   ​FULL OUTER JOIN

Question 11

A(n)non-equality join is used when there are no equivalent rows of data in the tables that are being joined._________________________​

Accepted Answer

A) True 
 B)False

Question 12

A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.​

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)   SELECT lastname,firstnameFROM customersWHERE orderdate = '12-APR-03';
B)   SELECT lastname,firstnameFROM customers NATURAL JOIN ordersWHERE orderdate = '12-APR-03';
C)   SELECT lastname,firstnameFROM customers JOIN orders ON (customer#) WHERE orderdate = '12-APR-03';
D)   ​both a and b

Question 14

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?

Accepted Answer

A)   SELECT title,cost,contact,phoneFROM publisher,books;
B)   SELECT title,cost,contact,phoneFROM publisher JOIN booksUSING (pubid) ;
C)   SELECT title,cost,contact,phoneFROM publisher JOIN booksUSING (isbn) ;
D)   SELECT title,cost,contact,phoneFROM publisher JOIN booksUSING (contact) ;

Question 15

A(n)Cartesian Join replicates each row from the first table with every row from the second table._________________________​

Accepted Answer

A) True 
 B)False

Question 16

Explain the difference between an inner join and an outer join.

Accepted Answer

An inner join only returns rows from one...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

​In which of the following examples is the ORDERS table used as a column qualifier?

Accepted Answer

A)   ​o.order#
B)   ​orders.order#
C)   ​order#.o
D)   ​order#.orders

Question 19

If you are attempting to join two tables that have multiple common columns,which of the following JOIN keywords should be used to specify how the tables should be linked?​

Accepted Answer

A)   ​OUTER JOIN
B)   ​CROSS JOIN
C)   ​JOIN...USING
D)   ​none of the above

Question 20

​A(n) ____ is used to combine the results of two queries.

Accepted Answer

A)   ​concatenation operator
B)   ​set operator
C)   ​comparison operator
D)   ​logical operator

Exam 9: Joining Data From Multiple Tables

​A table alias can consist of a maximum of ____ characters.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A(n)non-equality join is used when there are no equivalent rows of data in the tables that are being joined._________________________​

Correct AnswerverifiedShow Answer

A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A(n)non-equality join is also known as an equijoin,inner join,or simple join._________________________​

Correct AnswerverifiedShow Answer

A(n)non-equality join is when a table is joined to itself._________________________​

Correct AnswerverifiedShow Answer

Explain the difference between an inner join and an outer join.

Correct AnswerverifiedAn inner join only returns rows from one...View AnswerShow Answer

​In which of the following examples is the ORDERS table used as a column qualifier?

Correct AnswerverifiedShow Answer

A(n)Cartesian Join replicates each row from the first table with every row from the second table._________________________​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

​A(n) ____ is used to combine the results of two queries.

Correct AnswerverifiedShow Answer

​The outer join operator is placed on the side of the joining condition that has ____________________ rows.

Correct Answerverified​deficient...View AnswerShow Answer

A column qualifier indicates the column containing the data being referenced._________________________​

Correct AnswerverifiedShow Answer

A cross join between two tables,containing four rows each,will display eight rows in its output._________________________​

Correct AnswerverifiedShow Answer

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?​

Correct AnswerverifiedShow Answer

The JOIN keyword is included in which of the following clauses?​

Correct AnswerverifiedShow Answer

The ____________________ keywords create a join automatically between two tables,based on columns with matching names.

Correct AnswerverifiedShow Answer

If you are attempting to join two tables that have multiple common columns,which of the following JOIN keywords should be used to specify how the tables should be linked?​

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

A table alias can consist of a maximum of ____ characters.

Correct Answer
verified

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

Correct Answer
verified

A(n)non-equality join is used when there are no equivalent rows of data in the tables that are being joined._________________________

Correct Answer
verified

A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.

Correct Answer
verified

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

Correct Answer
verified

A(n)non-equality join is also known as an equijoin,inner join,or simple join._________________________

Correct Answer
verified

A(n)non-equality join is when a table is joined to itself._________________________

Correct Answer
verified

Correct Answer
verified
An inner join only returns rows from one...
View Answer

In which of the following examples is the ORDERS table used as a column qualifier?

Correct Answer
verified

A(n)Cartesian Join replicates each row from the first table with every row from the second table._________________________

Correct Answer
verified

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?

Correct Answer
verified

A(n) ____ is used to combine the results of two queries.

Correct Answer
verified

The outer join operator is placed on the side of the joining condition that has ____________________ rows.

Correct Answer
verified
deficient...
View Answer

A column qualifier indicates the column containing the data being referenced._________________________

Correct Answer
verified

A cross join between two tables,containing four rows each,will display eight rows in its output._________________________

Correct Answer
verified

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?

Correct Answer
verified

The JOIN keyword is included in which of the following clauses?

Correct Answer
verified

Correct Answer
verified

If you are attempting to join two tables that have multiple common columns,which of the following JOIN keywords should be used to specify how the tables should be linked?

Correct Answer
verified

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?

Correct Answer
verified