Filters
Question type
Study Flashcards

Set operators are used to combine the results of multiple queries.

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

A(n)  non-equality ‾\underline {\text { non-equality }} join is when a table is joined to itself. _________________________

Correct Answer

verifed

verified

When using the JOIN...ON keywords to join four tables, both keywords must be repeated four times.

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 the names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY? A) SELECT lastname, firstname FROM customers NATURAL JOIN books WHERE title LIKE '%BUSI%'; B) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE title LIKE '%BUSI%'; C) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE c.customer# = o.customer# AND o.order# = oi.order# AND Oi) isbn = b.isbn AND title LIKE '%BUSI%'; D) none of the above 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 the names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY? A) SELECT lastname, firstname FROM customers NATURAL JOIN books WHERE title LIKE '%BUSI%'; B) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE title LIKE '%BUSI%'; C) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE c.customer# = o.customer# AND o.order# = oi.order# AND Oi) isbn = b.isbn AND title LIKE '%BUSI%'; D) none of the above 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 the names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY? A) SELECT lastname, firstname FROM customers NATURAL JOIN books WHERE title LIKE '%BUSI%'; B) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE title LIKE '%BUSI%'; C) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE c.customer# = o.customer# AND o.order# = oi.order# AND Oi) isbn = b.isbn AND title LIKE '%BUSI%'; D) none of the above 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 the names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY? A) SELECT lastname, firstname FROM customers NATURAL JOIN books WHERE title LIKE '%BUSI%'; B) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE title LIKE '%BUSI%'; C) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi WHERE c.customer# = o.customer# AND o.order# = oi.order# AND Oi) isbn = b.isbn AND title LIKE '%BUSI%'; D) none of the above Structure of the BOOKS table -Which of the following SQL statements will display the names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY?


A) SELECT lastname, firstname
FROM customers NATURAL JOIN books
WHERE title LIKE '%BUSI%';
B) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi
WHERE title LIKE '%BUSI%';
C) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi
WHERE c.customer# = o.customer# AND o.order# = oi.order# AND
Oi) isbn = b.isbn AND title LIKE '%BUSI%';
D) none of the above

Correct Answer

verifed

verified

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?


A) OUTER JOIN
B) CROSS JOIN
C) JOIN...USING
D) none of the above

Correct Answer

verifed

verified

The outer join operator in the WHERE clause cannot be used with which of the following operators?


A) IN
B) OR
C) AND
D) both a and b

Correct Answer

verifed

verified

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $35.95? A) SELECT name, title, retail FROM books, publisher WHERE cost > 35.95; B) SELECT name, title, retail FROM books NATURAL JOIN publisher WHERE cost > 35.95; C) SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p WHERE b.cost > 35.95; D) none of the above Structure of the BOOKS table Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $35.95? A) SELECT name, title, retail FROM books, publisher WHERE cost > 35.95; B) SELECT name, title, retail FROM books NATURAL JOIN publisher WHERE cost > 35.95; C) SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p WHERE b.cost > 35.95; D) none of the above Structure of the PUBLISHER table -Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $35.95?


A) SELECT name, title, retail
FROM books, publisher
WHERE cost > 35.95;
B) SELECT name, title, retail FROM books NATURAL JOIN publisher
WHERE cost > 35.95;
C) SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p
WHERE b.cost > 35.95;
D) none of the above

Correct Answer

verifed

verified

A(n)  Cartesian Join ‾\underline {\text { Cartesian Join }} replicates each row from the first table with every row from the second table. _________________________

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

A(n)  inner join ‾\underline { \text { inner join }} will only include rows that have matching rows in the other table. _________________________

Correct Answer

verifed

verified

Showing 121 - 131 of 131

Related Exams

Exam 1

Overview of Database Concepts

108 Questions

Exam 2

Basic Sql Select Statements

122 Questions

Exam 3

Table Creation and Management

132 Questions

Exam 4

Constraints

132 Questions

Exam 5

Data Manipulation and Transaction Control

132 Questions

Exam 6

Additional Database Objects

132 Questions

Exam 7

User Creation and Management

132 Questions

Exam 8

Restricting Rows and Sorting Data

132 Questions

Exam 10

Selected Single Row Functions

133 Questions

Exam 11

Group Functions

134 Questions

Exam 12

Subqueries and Merge Statements

132 Questions

Exam 13

Views

133 Questions

Show Answer