Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

Accepted Answer

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

Question 4

A table alias can have a maximum of ____________________ characters.

Accepted Answer

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

Question 5

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 6

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

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 8

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

Accepted Answer

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

Question 9

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 10

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 o
ON 
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#); 
A)  SELECT lastname, firstname, order#
FROM customers NATURAL JOIN orders; 
B)  SELECT lastname, firstname, order#
FROM customers c LEFT OUTER JOIN orders o
ON 
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 11

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 
A)  OUTER JOIN 
B)  CROSS JOIN 
C)  NATURAL JOIN 
D)  JOIN...USING

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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 18

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 
A)  common column 
B)  equiv-column 
C)  inner columns 
D)  simple columns

Question 19

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 20

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

Accepted Answer

A)  SELECT title
FROM customers NATURAL JOIN orders
NATURAL JOIN orderitems NATURAL JOIN books
WHERE orderdate - pubdate >= 3; 
B)  SELECT title,
FROM orders o, orderitems oi, books b
WHERE 
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 b
WHERE.. 
A)  SELECT title
FROM customers NATURAL JOIN orders
NATURAL JOIN orderitems NATURAL JOIN books
WHERE orderdate - pubdate >= 3; 
B)  SELECT title,
FROM orders o, orderitems oi, books b
WHERE 
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 b
WHERE..

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

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.

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

A table alias can have a maximum of ____________________ characters.

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

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

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.

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

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?

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

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

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

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.

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

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

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

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

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

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

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

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

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.

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

A table alias can have a maximum of ____________________ characters.

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

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

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.

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

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?

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

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

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

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.

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

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

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

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

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

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

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 you are joining four tables in a SELECT statement, $\underline { \text { three } }$ joining conditions will be required. _________________________

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

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

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