Filters
Question type
Study Flashcards

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

A) True
B) False

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

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

​ 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

E) A) and D)
F) B) and C)

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

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

​Explain the purpose of a set operator.

Correct Answer

verifed

verified

A set operator is us...

View Answer

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

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

E) B) and C)
F) C) and D)

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

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

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

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;

E) A) and D)
F) A) and B)

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

A) True
B) False

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

E) A) and C)
F) None of the above

Correct Answer

verifed

verified

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

A) True
B) False

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

E) None of the above
F) B) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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