Question 1

The MINUS set operator is used to display rows that were uniquely returned by the first query in the set.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Which of the following terms refers to a column with equivalent data that exists in two or more tables?

Accepted Answer

A)   common column
B)   equiv-column
C)   inner columns
D)   simple columns

Question 4

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.

Accepted Answer

A) True 
 B)False

Question 5

The $\underline { \text { ON } }$ clause can be used only if the tables being joined have a common column with the same name. _________________________

Accepted Answer

A) True 
 B)False

Question 6

The JOIN keyword must be used in the $\underline { \text { WHERE } }$clause of a SELECT statement. _________________________

Accepted Answer

A) True 
 B)False

Question 7

Which of the following will display all books that were published at least three years before they were ordered?

Accepted Answer

A)   SELECT titleFROM customers NATURAL JOIN ordersNATURAL JOIN orderitems NATURAL JOIN booksWHERE orderdate - pubdate >= 3;
B)   SELECT title,FROM orders o, orderitems oi, books bWHERE
C)  isbn = oi.isbn AND oi.order# = o.order# AND (orderdate-pubdate) /365 >= 3;.
D)  isbn = oi.isbn AND oi.order# = o.order# AND orderdate - pubdate >= 3;,
E)   SELECT title.FROM orders o, orderitems oi, books bWHERE..

Question 8

When a self-join is created, each copy of the table must be assigned a table alias.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ JOIN keyword can be used to create a Cartesian join.

Accepted Answer

The answer of The ____________________ JOIN keyword can be used...

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

A self-join can only be specified in the FROM clause with the use of the JOIN...____________________ keywords.

Accepted Answer

The answer of A self-join can only be specified in...

Question 12

A table alias can have a maximum of ____________________ characters.

Accepted Answer

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

Question 13

A cross join between two tables, containing four rows each, will display $\underline { \text { eight } }$ rows in its output. _________________________

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

Which of the following keywords is used to create a Cartesian join?

Accepted Answer

A)   OUTER JOIN
B)   CROSS JOIN
C)   NATURAL JOIN
D)   JOIN...USING

Question 16

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?

Accepted Answer

A)   SELECT lastname, firstname, order#FROM customers NATURAL JOIN orders;
B)   SELECT lastname, firstname, order#FROM customers c LEFT OUTER JOIN orders oON
C)   SELECT lastname, firstname, order#FROM customers RIGHT OUTER JOIN orders;
D)  customer# = o.customer#;
E)   SELECT lastname, firstname, order#FROM customers JOIN orders USING (customer#) ;

Question 17

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

Accepted Answer

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

Question 18

Which of the following is an example of assigning "o" as a table alias for the ORDERS table in the FROM clause?

Accepted Answer

A)   FROM o orders, c customers
B)   FROM o.orders,
C)   FROM orders o, customers c
D)  customers
E)   FROM orders.o, customers.c

Question 19

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

Accepted Answer

The answer of ____________________ operators are used to combine the...

Question 20

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

Exam 9: Joining Data From Multiple Tables

Which of the following is an example of assigning "o" as a table alias for the ORDERS table in the FROM clause?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A table alias can have a maximum of ____________________ characters.

Correct AnswerverifiedShow Answer

Which of the following terms refers to a column with equivalent data that exists in two or more tables?

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A cross join between two tables, containing four rows each, will display eight ‾\underline { \text { eight } } eight ​ rows in its output. _________________________

Correct AnswerverifiedShow Answer

The MINUS set operator is used to display rows that were uniquely returned by the first query in the set.

Correct AnswerverifiedShow Answer

Which of the following will display all books that were published at least three years before they were ordered?

Correct AnswerverifiedShow Answer

The ____________________ JOIN keyword can be used to create a Cartesian join.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ON ‾\underline { \text { ON } } ON ​ clause can be used only if the tables being joined have a common column with the same name. _________________________

Correct AnswerverifiedShow Answer

The JOIN keyword must be used in the WHERE ‾\underline { \text { WHERE } } WHERE ​ clause of a SELECT statement. _________________________

Correct AnswerverifiedShow Answer

A self-join can only be specified in the FROM clause with the use of the JOIN...____________________ keywords.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

When a self-join is created, each copy of the table must be assigned a table alias.

Correct AnswerverifiedShow Answer

Which of the following keywords is used to create a Cartesian join?

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

A cross join between two tables, containing four rows each, will display $\underline { \text { eight } }$ rows in its output. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

The $\underline { \text { ON } }$ clause can be used only if the tables being joined have a common column with the same name. _________________________

Correct Answer
verified

The JOIN keyword must be used in the $\underline { \text { WHERE } }$ clause of a SELECT statement. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified