Question 1

The INTERSECT set operator only displays the rows returned by both queries.​

Accepted Answer

A) True 
 B)False  True

Question 2

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

Question 3

The outer join operator is placed on the side of the comparison that is deficient or is missing the matching rows.​

Accepted Answer

A) True 
 B)False  True

Question 4

By default,use of the JOIN keyword creates an inner join.​

Accepted Answer

A) True 
 B)False

Question 5

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 the title of the books ordered by customer# 1003?​

Accepted Answer

A)  ​SELECT title
FROM customers NATURAL JOIN books
WHERE customer# = 1003; 
B)  ​SELECT title
FROM customers JOIN orders USING (customer#)
JOIN orderitems USING (order#)JOIN books USING (isbn)
WHERE customer# = 1003; 
C)  ​SELECT title
FROM customers JOIN orders ON (customer#)
JOIN orderitems ON (order#)JOIN books ON (isbn)
WHERE customer# = 1003; 
D)  ​both a and b 
A)  ​SELECT title
FROM customers NATURAL JOIN books
WHERE customer# = 1003; 
B)  ​SELECT title
FROM customers JOIN orders USING (customer#)
JOIN orderitems USING (order#)JOIN books USING (isbn)
WHERE customer# = 1003; 
C)  ​SELECT title
FROM customers JOIN orders ON (customer#)
JOIN orderitems ON (order#)JOIN books ON (isbn)
WHERE customer# = 1003; 
D)  ​both a and b

Question 6

Which of the following types of joins refers to results consisting of each row from the first table being replicated from every row in the second table?​

Accepted Answer

A)  ​outer join 
B)  ​non-equality join 
C)  ​self-join 
D)  ​Cartesian join 
A)  ​outer join 
B)  ​non-equality join 
C)  ​self-join 
D)  ​Cartesian join

Question 7

Data stored in separate tables can be reconstructed through the use of ____________________.​

Accepted Answer

joins
join

Question 8

The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.​

Accepted Answer

A) True 
 B)False

Question 9

The outer join operator is used to combine the results of multiple SELECT statements._________________________​

Accepted Answer

A) True 
 B)False

Question 10

The JOIN keyword must be used in the WHERE clause of a SELECT statement._________________________​

Accepted Answer

A) True 
 B)False

Question 11

Structure of the CUSTOMERS table
   ​
Structure of the ORDERS table
   Structure of the ORDERITEMS table
   Structure of the BOOKS table
-​To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?

Accepted Answer

A)  ​4 
B)  ​3 
C)  ​2 
D)  ​1 
A)  ​4 
B)  ​3 
C)  ​2 
D)  ​1

Question 12

An outer join operator consists of a minus sign enclosed in parentheses, (-).​

Accepted Answer

A) True 
 B)False

Question 13

​A join that is based upon data having equivalent data in common columns is known as a(n)____________________ join.

Accepted Answer

inner
equa

Question 14

Structure of the BOOKS table
   Structure of the PUBLISHER table
-Which of the following will display the title,publication date,and publisher name of each book in the BUSINESS category?​

Accepted Answer

A)  SELECT title,pubdate,name
FROM publisher JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
B)  SELECT title,pubdate,name
FROM publisher JOIN books ON (pubid)
WHERE category = 'BUSINESS'; 
C)  SELECT title,pubdate,name
FROM publisher OUTER JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
D)  SELECT title,pubdate,name
FROM publisher CROSS JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
A)  SELECT title,pubdate,name
FROM publisher JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
B)  SELECT title,pubdate,name
FROM publisher JOIN books ON (pubid)
WHERE category = 'BUSINESS'; 
C)  SELECT title,pubdate,name
FROM publisher OUTER JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
D)  SELECT title,pubdate,name
FROM publisher CROSS JOIN books USING (pubid)
WHERE category = 'BUSINESS';

Question 15

​Which of the following types of joins refers to joining a table to itself?

Accepted Answer

A)  ​Cartesian join 
B)  ​equality join 
C)  ​self-join 
D)  ​outer join 
A)  ​Cartesian join 
B)  ​equality join 
C)  ​self-join 
D)  ​outer join

Question 16

A(n)____________________ join is used when the related columns between two tables cannot be joined through an equal sign.

Accepted Answer

non-equali

Question 17

​The ____________________ set operator is used to display the rows returned by both SELECT statements.

Accepted Answer

The answer of ​The ____________________ set operator is used to...

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

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

Accepted Answer

A) True 
 B)False

Question 20

​A column qualifier is separated from the column using which symbol?

Accepted Answer

A)  ​comma (,) 
B)  ​plus sign (+) 
C)  ​period (. ) 
D)  ​percent sign (%) 
A)  ​comma (,) 
B)  ​plus sign (+) 
C)  ​period (. ) 
D)  ​percent sign (%)

The INTERSECT set operator only displays the rows returned by both queries.

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

The outer join operator is placed on the side of the comparison that is deficient or is missing the matching rows.

By default,use of the JOIN keyword creates an inner 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 the title of the books ordered by customer# 1003?

Which of the following types of joins refers to results consisting of each row from the first table being replicated from every row in the second table?

Data stored in separate tables can be reconstructed through the use of ____________________.

The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.

The outer join operator is used to combine the results of multiple SELECT statements._________________________

The JOIN keyword must be used in the WHERE clause of a SELECT statement._________________________

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?

An outer join operator consists of a minus sign enclosed in parentheses, (-).

A join that is based upon data having equivalent data in common columns is known as a(n)____________________ join.

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following will display the title,publication date,and publisher name of each book in the BUSINESS category?

Which of the following types of joins refers to joining a table to itself?

A(n)____________________ join is used when the related columns between two tables cannot be joined through an equal sign.

The ____________________ set operator is used to display the rows returned by both SELECT statements.

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

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

A column qualifier is separated from the column using which symbol?

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 INTERSECT set operator only displays the rows returned by both queries.​

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

The outer join operator is placed on the side of the comparison that is deficient or is missing the matching rows.​

By default,use of the JOIN keyword creates an inner 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 the title of the books ordered by customer# 1003?​

Which of the following types of joins refers to results consisting of each row from the first table being replicated from every row in the second table?​

Data stored in separate tables can be reconstructed through the use of ____________________.​

The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.​

The outer join operator is used to combine the results of multiple SELECT statements._________________________​

The JOIN keyword must be used in the WHERE clause of a SELECT statement._________________________​

Structure of the CUSTOMERS table ​ Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -​To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?

An outer join operator consists of a minus sign enclosed in parentheses, (-).​

​A join that is based upon data having equivalent data in common columns is known as a(n)____________________ join.

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following will display the title,publication date,and publisher name of each book in the BUSINESS category?​

​Which of the following types of joins refers to joining a table to itself?

A(n)____________________ join is used when the related columns between two tables cannot be joined through an equal sign.

​The ____________________ set operator is used to display the rows returned by both SELECT statements.

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

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

​A column qualifier is separated from the column using which symbol?

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 INTERSECT set operator only displays the rows returned by both queries.

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

The outer join operator is placed on the side of the comparison that is deficient or is missing the matching rows.

By default,use of the JOIN keyword creates an inner 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 the title of the books ordered by customer# 1003?

Which of the following types of joins refers to results consisting of each row from the first table being replicated from every row in the second table?

Data stored in separate tables can be reconstructed through the use of ____________________.

The USING clause must be used with the JOIN keyword when linking tables that do not contain a commonly named column.

The outer join operator is used to combine the results of multiple SELECT statements._________________________

The JOIN keyword must be used in the WHERE clause of a SELECT statement._________________________

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?

An outer join operator consists of a minus sign enclosed in parentheses, (-).

A join that is based upon data having equivalent data in common columns is known as a(n)____________________ join.

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following will display the title,publication date,and publisher name of each book in the BUSINESS category?

Which of the following types of joins refers to joining a table to itself?

The ____________________ set operator is used to display the rows returned by both SELECT statements.

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

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

A column qualifier is separated from the column using which symbol?