Filters
Question type
Study Flashcards

The ON clause can be used only if the tables being joined have a common column with the same name._________________________​

Correct Answer

verifed

verified

​ Contents of the PROMOTION table Structure of the BOOKS table -Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled THE WOK WAY TO COOK?​ A) SELECT title FROM promotion WHERE retail BETWEEN minretail AND maxretail; B) SELECT title FROM promotion NATURAL JOIN books WHERE retail BETWEEN minretail AND maxretail; C) SELECT title FROM promotion JOIN books USING retail BETWEEN minretail AND maxretail; D) ​none of the above ​ Contents of the PROMOTION table ​ Contents of the PROMOTION table Structure of the BOOKS table -Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled THE WOK WAY TO COOK?​ A) SELECT title FROM promotion WHERE retail BETWEEN minretail AND maxretail; B) SELECT title FROM promotion NATURAL JOIN books WHERE retail BETWEEN minretail AND maxretail; C) SELECT title FROM promotion JOIN books USING retail BETWEEN minretail AND maxretail; D) ​none of the above Structure of the BOOKS table -Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled THE WOK WAY TO COOK?​


A) SELECT title FROM promotion
WHERE retail BETWEEN minretail AND maxretail;
B) SELECT title FROM promotion NATURAL JOIN books
WHERE retail BETWEEN minretail AND maxretail;
C) SELECT title FROM promotion JOIN books
USING retail BETWEEN minretail AND maxretail;
D) ​none of the above

Correct Answer

verifed

verified

​Which of the following keywords is used to create an equality join?


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

Correct Answer

verifed

verified

The ____________________ operator is used to create an outer join in the WHERE clause of a SQL statement.

Correct Answer

verifed

verified

Joins are classified as ____________________ joins if the results can only contain the rows that had matching values in each table,rather than rows being matched with NULL values.​

Correct Answer

verifed

verified

Tables can be joined in the FROM clause or the WHERE clause of a SELECT statement._________________________​

Correct Answer

verifed

verified

A column qualifier is separated from the column name with a colon.​

Correct Answer

verifed

verified

The outer join operator is placed on the side of the joining condition that references the table containing the deficient rows._________________________​

Correct Answer

verifed

verified

Equality,non-equality,and self-joins are broadly categorized as outer joins._________________________​

Correct Answer

verifed

verified

​ 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? A) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NOT NULL; B) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# (+) = customers.customer#; C) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# = customers.customer# (+) ; D) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NULL; ​ Structure of the ORDERS table ​ 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? A) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NOT NULL; B) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# (+) = customers.customer#; C) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# = customers.customer# (+) ; D) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NULL; 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?


A) SELECT lastname,firstname,order#
FROM customers NATURAL JOIN orders
WHERE orders.customer# IS NOT NULL;
B) SELECT lastname,firstname,order#
FROM customers,orders
WHERE orders.customer# (+) = customers.customer#;
C) SELECT lastname,firstname,order#
FROM customers,orders
WHERE orders.customer# = customers.customer# (+) ;
D) SELECT lastname,firstname,order#
FROM customers NATURAL JOIN orders
WHERE orders.customer# IS NULL;

Correct Answer

verifed

verified

​Which of the following set operators can be used to make certain that only the rows returned by both queries are displayed in the results?


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

Correct Answer

verifed

verified

​ Contents of the PROMOTION table Structure of the BOOKS table -How many joining conditions will be required in an SQL statement that is used to determine the gift that corresponds to each book in the BOOKS table?​ A) ​4 B) ​3 C) ​2 D) ​1 ​ Contents of the PROMOTION table ​ Contents of the PROMOTION table Structure of the BOOKS table -How many joining conditions will be required in an SQL statement that is used to determine the gift that corresponds to each book in the BOOKS table?​ A) ​4 B) ​3 C) ​2 D) ​1 Structure of the BOOKS table -How many joining conditions will be required in an SQL statement that is used to determine the gift that corresponds to each book in the BOOKS table?​


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

Correct Answer

verifed

verified

The JOIN...USING keywords are used to join two tables that do not have a commonly named and defined column._________________________​

Correct Answer

verifed

verified

When combining the results of two SELECT statements with the MINUS keyword,duplicate rows are suppressed in the results._________________________​

Correct Answer

verifed

verified

When combining the results of two SELECT statements with the UNION keyword,duplicate rows are suppressed in the results._________________________​

Correct Answer

verifed

verified

The ____________________ keyword can be included in the FROM clause to link tables.​

Correct Answer

verifed

verified

​ Structure of the ORDERS table Structure of the CUSTOMERS table ​ -Which of the following SQL statements will display all customers who have not recently placed an order?​ A) ​SELECT customer# FROM customers UNION SELECT customer# FROM orders; B) ​SELECT customer# FROM orders MINUS SELECT customer# FROM customers; C) ​SELECT customer# FROM orders INTERSECT SELECT customer# FROM customers; D) ​SELECT customer# FROM customers MINUS SELECT customer# FROM orders; ​ Structure of the ORDERS table ​ Structure of the ORDERS table Structure of the CUSTOMERS table ​ -Which of the following SQL statements will display all customers who have not recently placed an order?​ A) ​SELECT customer# FROM customers UNION SELECT customer# FROM orders; B) ​SELECT customer# FROM orders MINUS SELECT customer# FROM customers; C) ​SELECT customer# FROM orders INTERSECT SELECT customer# FROM customers; D) ​SELECT customer# FROM customers MINUS SELECT customer# FROM orders; Structure of the CUSTOMERS table ​ -Which of the following SQL statements will display all customers who have not recently placed an order?​


A) ​SELECT customer# FROM customers
UNION
SELECT customer# FROM orders;
B) ​SELECT customer# FROM orders
MINUS
SELECT customer# FROM customers;
C) ​SELECT customer# FROM orders
INTERSECT
SELECT customer# FROM customers;
D) ​SELECT customer# FROM customers
MINUS
SELECT customer# FROM orders;

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

​ 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?​ A) SELECT lastname,firstname,order# FROM orders RIGHT OUTER JOIN customers USING (customer#) ; B) SELECT lastname,firstname,order# FROM orders LEFT OUTER JOIN customers USING (customer#) ; C) SELECT lastname,firstname,order# FROM orders FULL OUTER JOIN customers USING (customer#) ; D) ​both a and c ​ Structure of the ORDERS table ​ 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?​ A) SELECT lastname,firstname,order# FROM orders RIGHT OUTER JOIN customers USING (customer#) ; B) SELECT lastname,firstname,order# FROM orders LEFT OUTER JOIN customers USING (customer#) ; C) SELECT lastname,firstname,order# FROM orders FULL OUTER JOIN customers USING (customer#) ; D) ​both a and c 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?​


A) SELECT lastname,firstname,order#
FROM orders RIGHT OUTER JOIN customers
USING (customer#) ;
B) SELECT lastname,firstname,order#
FROM orders LEFT OUTER JOIN customers
USING (customer#) ;
C) SELECT lastname,firstname,order#
FROM orders FULL OUTER JOIN customers
USING (customer#) ;
D) ​both a and c

Correct Answer

verifed

verified

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 Answer

verifed

verified

Showing 21 - 40 of 119

Related Exams

Exam 1

Overview of Database Concepts

108 Questions

Exam 2

Basic SQL Select Statements

121 Questions

Exam 3

Table Creation and Management

136 Questions

Exam 4

Constraints

132 Questions

Exam 5

Data Manipulation and Transaction Control

136 Questions

Exam 6

Additional Database Objects

138 Questions

Exam 7

User Creation and Management

130 Questions

Exam 8

Restricting Rows and Sorting Data

132 Questions

Exam 10

Selected Single-Row Functions

133 Questions

Exam 11

Group Functions

137 Questions

Exam 12

Subqueries and Merge Statements

131 Questions

Exam 13

Views

133 Questions

Show Answer