Question 1

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

Accepted Answer

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

Question 2

Structure of the CUSTOMERS table
   ​
Structure of the ORDERS table
   Structure of the ORDERITEMS table
   Structure of the BOOKS table
-Which of the following SQL statements will display books that have not been ordered recently?​

Accepted Answer

A)  ​SELECT title
FROM books,orderitems
WHERE books.isbn  orderitems.isbn; 
B)  ​SELECT title
FROM books NATURAL JOIN orderitems
WHERE JOIN IS NULL; 
C)  ​SELECT title FROM books NATURAL JOIN orderitems
MINUS
SELECT title FROM books; 
D)  ​SELECT title FROM books
MINUS
SELECT title FROM books NATURAL JOIN orderitems; 
A)  ​SELECT title
FROM books,orderitems
WHERE books.isbn  orderitems.isbn; 
B)  ​SELECT title
FROM books NATURAL JOIN orderitems
WHERE JOIN IS NULL; 
C)  ​SELECT title FROM books NATURAL JOIN orderitems
MINUS
SELECT title FROM books; 
D)  ​SELECT title FROM books
MINUS
SELECT title FROM books NATURAL JOIN orderitems;

Question 3

​Explain the purpose of a set operator.

Accepted Answer

A set operator is us

Question 4

Give the appropriate situation in which to use each of the following join keywords: NATURAL JOIN,JOIN...USING,and JOIN...ON.

Accepted Answer

The NATURAL JOIN keywords create a join

Question 5

The NATURAL JOIN keywords can be used to create non-equality joins.​

Accepted Answer

A) True 
 B)False

Question 6

A Cartesian join can be created by not including a joining condition in the WHERE clause of a SELECT statement._________________________​

Accepted Answer

A) True 
 B)False

Question 7

The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column.​

Accepted Answer

A) True 
 B)False

Question 8

In a Cartesian join,linking a table that contains 10 rows to a table that contains 9 rows will result in ____ rows being displayed in the output.​

Accepted Answer

A)  ​19 
B)  ​18 
C)  ​90 
D)  ​89 
A)  ​19 
B)  ​18 
C)  ​90 
D)  ​89

Question 9

If you are joining two tables in a SELECT statement,three joining conditions will be required._________________________​

Accepted Answer

A) True 
 B)False

Question 10

​
Structure of the ORDERS table
   Structure of the CUSTOMERS table
​
-​Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?

Accepted Answer

A)  ​SELECT * FROM orders,customers; 
B)  SELECT lastname,firstname,order#
FROM orders NATURAL JOIN customers; 
C)  SELECT lastname,firstname,order#
FROM orders,customers
WHERE orders.customer# = customers.customer#; 
D)  ​all of the above 
A)  ​SELECT * FROM orders,customers; 
B)  SELECT lastname,firstname,order#
FROM orders NATURAL JOIN customers; 
C)  SELECT lastname,firstname,order#
FROM orders,customers
WHERE orders.customer# = customers.customer#; 
D)  ​all of the above

Question 11

​Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?

Accepted Answer

A)  ​NATURAL JOIN 
B)  ​JOIN...ON 
C)  ​JOIN...USING 
D)  ​none of the above 
A)  ​NATURAL JOIN 
B)  ​JOIN...ON 
C)  ​JOIN...USING 
D)  ​none of the above

Question 12

​Which of the following can only be used to link tables that have a common column?

Accepted Answer

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

Question 13

A(n)inner join will only include rows that have matching rows in the other table._________________________​

Accepted Answer

A) True 
 B)False

Question 14

If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows,there will be 13 rows in the results.​

Accepted Answer

A) True 
 B)False

Question 15

​Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?

Accepted Answer

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

Question 16

A column qualifier is used to indicate the table containing the column being referenced.​

Accepted Answer

A) True 
 B)False

Question 17

Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.​

Accepted Answer

A) True 
 B)False

Question 18

A(n)outer join can be created by not including a joining condition in a SELECT statement._________________________​

Accepted Answer

A) True 
 B)False

Question 19

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

In Oracle12c,tables can be linked through which clause(s)?​

Accepted Answer

A)  ​SELECT 
B)  ​FROM 
C)  ​WHERE 
D)  ​both b and c 
A)  ​SELECT 
B)  ​FROM 
C)  ​WHERE 
D)  ​both b and c

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

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -Which of the following SQL statements will display books that have not been ordered recently?

Explain the purpose of a set operator.

Give the appropriate situation in which to use each of the following join keywords: NATURAL JOIN,JOIN...USING,and JOIN...ON.

The NATURAL JOIN keywords can be used to create non-equality joins.

A Cartesian join can be created by not including a joining condition in the WHERE clause of a SELECT statement._________________________

The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column.

In a Cartesian join,linking a table that contains 10 rows to a table that contains 9 rows will result in ____ rows being displayed in the output.

If you are joining two tables in a SELECT statement,three joining conditions will be required._________________________

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?

Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?

Which of the following can only be used to link tables that have a common column?

A(n)inner join will only include rows that have matching rows in the other table._________________________

If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows,there will be 13 rows in the results.

Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?

A column qualifier is used to indicate the table containing the column being referenced.

Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.

A(n)outer join can be created by not including a joining condition in a SELECT statement._________________________

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

In Oracle12c,tables can be linked through which clause(s)?

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 ____________________ JOIN keyword can be used to create a Cartesian join.

Structure of the CUSTOMERS table ​ Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -Which of the following SQL statements will display books that have not been ordered recently?​

​Explain the purpose of a set operator.

Give the appropriate situation in which to use each of the following join keywords: NATURAL JOIN,JOIN...USING,and JOIN...ON.

The NATURAL JOIN keywords can be used to create non-equality joins.​

A Cartesian join can be created by not including a joining condition in the WHERE clause of a SELECT statement._________________________​

The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column.​

In a Cartesian join,linking a table that contains 10 rows to a table that contains 9 rows will result in ____ rows being displayed in the output.​

If you are joining two tables in a SELECT statement,three joining conditions will be required._________________________​

​ Structure of the ORDERS table Structure of the CUSTOMERS table ​ -​Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?

​Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?

​Which of the following can only be used to link tables that have a common column?

A(n)inner join will only include rows that have matching rows in the other table._________________________​

If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows,there will be 13 rows in the results.​

​Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?

A column qualifier is used to indicate the table containing the column being referenced.​

Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.​

A(n)outer join can be created by not including a joining condition in a SELECT statement._________________________​

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

In Oracle12c,tables can be linked through which clause(s)?​

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

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

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -Which of the following SQL statements will display books that have not been ordered recently?

Explain the purpose of a set operator.

The NATURAL JOIN keywords can be used to create non-equality joins.

A Cartesian join can be created by not including a joining condition in the WHERE clause of a SELECT statement._________________________

The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column.

In a Cartesian join,linking a table that contains 10 rows to a table that contains 9 rows will result in ____ rows being displayed in the output.

If you are joining two tables in a SELECT statement,three joining conditions will be required._________________________

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?

Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?

Which of the following can only be used to link tables that have a common column?

A(n)inner join will only include rows that have matching rows in the other table._________________________

If a Cartesian join is used to link table A which contains five rows to table B which contains eight rows,there will be 13 rows in the results.

Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?

A column qualifier is used to indicate the table containing the column being referenced.

Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.

A(n)outer join can be created by not including a joining condition in a SELECT statement._________________________

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

In Oracle12c,tables can be linked through which clause(s)?