Question 1

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 2

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

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

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 5

​
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,firstname
FROM customers
WHERE orderdate = '12-APR-03'; 
B)  SELECT lastname,firstname
FROM customers NATURAL JOIN orders
WHERE orderdate = '12-APR-03'; 
C)  SELECT lastname,firstname
FROM customers JOIN orders ON (customer#)
WHERE orderdate = '12-APR-03'; 
D)  ​both a and b 
A)  SELECT lastname,firstname
FROM customers
WHERE orderdate = '12-APR-03'; 
B)  SELECT lastname,firstname
FROM customers NATURAL JOIN orders
WHERE orderdate = '12-APR-03'; 
C)  SELECT lastname,firstname
FROM customers JOIN orders ON (customer#)
WHERE orderdate = '12-APR-03'; 
D)  ​both a and b

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

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

Accepted Answer

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

Question 9

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 
A)  ​NATURAL JOIN 
B)  ​JOIN...ON 
C)  ​LEFT OUTER JOIN 
D)  ​FULL OUTER JOIN

Question 10

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 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

​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 
A)  ​o.order# 
B)  ​orders.order# 
C)  ​order#.o 
D)  ​order#.orders

Question 14

​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 
A)  ​concatenation operator 
B)  ​set operator 
C)  ​comparison operator 
D)  ​logical operator

Question 15

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,phone
FROM publisher,books; 
B)  SELECT title,cost,contact,phone
FROM publisher JOIN books
USING (pubid); 
C)  SELECT title,cost,contact,phone
FROM publisher JOIN books
USING (isbn); 
D)  SELECT title,cost,contact,phone
FROM publisher JOIN books
USING (contact); 
A)  SELECT title,cost,contact,phone
FROM publisher,books; 
B)  SELECT title,cost,contact,phone
FROM publisher JOIN books
USING (pubid); 
C)  SELECT title,cost,contact,phone
FROM publisher JOIN books
USING (isbn); 
D)  SELECT title,cost,contact,phone
FROM publisher JOIN books
USING (contact);

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

​deficient

Question 18

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

Accepted Answer

An inner join only returns rows from one

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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 
A)  ​OUTER JOIN 
B)  ​CROSS JOIN 
C)  ​JOIN...USING 
D)  ​none of the above

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

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

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

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.

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?

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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.

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?

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

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

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

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

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

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

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

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

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?

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

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

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

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?