Filters
Question type
Study Flashcards

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

Correct Answer

verifed

verified

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?​ 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; Structure of the CUSTOMERS table 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?​ 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; ​ Structure of the ORDERS table 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?​ 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; Structure of the ORDERITEMS table 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?​ 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; Structure of the BOOKS table -Which of the following SQL statements will display books that have not been ordered recently?​


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;

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

​Explain the purpose of a set operator.

Correct Answer

verifed

verified

A set operator is us...

View Answer

​ 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? 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 ​ Structure of the ORDERS table ​ 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? 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 Structure of the CUSTOMERS table ​ -​Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?


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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


A) ​OUTER JOIN
B) ​CROSS JOIN
C) ​NATURAL JOIN
D) ​JOIN...USING

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

The NATURAL JOIN keywords create a join ...

View Answer

Showing 61 - 80 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