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

A table alias can have a maximum of ____________________ characters.

Accepted Answer

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

Question 3

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#) ;F) B) and E)
G) A) and B)

Question 4

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 5

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..F) All of the above
G) A) and D)

Question 6

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 7

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

Accepted Answer

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

Question 8

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 columnsE) A) and C)
F) C) and D)

Question 9

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

Accepted Answer

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

Question 10

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...USINGE) All of the above
F) A) and D)

Question 11

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 12

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 13

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.cF) B) and D)
G) A) and E)

Question 14

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

Accepted Answer

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

Question 15

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 16

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 aboveE) A) and B)
F) B) and C)

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

Exam 9: Joining Data From Multiple Tables

A table alias can have a maximum of ____________________ characters.

Correct AnswerverifiedShow Answer

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

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

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

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 outer join operator can only be used in the ____________________ clause.

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

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

Correct AnswerverifiedShow Answer

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

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

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

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

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

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

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

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

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

Correct AnswerverifiedShow Answer

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

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

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

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

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified