CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 21

ADD MODIFY CHANGE RESET
8.( TCO 7) Any type of subquery can be used in the _________ clause of a SELECT statement.( Points: 4)
WHERE HAVING FROM ORDER BY GROUP Page 3- Multiple Choice
1.( TCO 7) Using the BOOK _ CUSTOMER and BOOK _ ORDER tables shown below for references, which SQL statement will return the same results as the following SQL statement?
SELECT * FROM book _ customer, book _ order;( Points: 4)
SELECT * FROM book _ order CROSS JOIN book _ customer;
SELECT * FROM book _ order, book _ customer

ADD MODIFY CHANGE RESET

8.( TCO 7) Any type of subquery can be used in the _________ clause of a SELECT statement.( Points: 4)

WHERE HAVING FROM ORDER BY GROUP Page 3- Multiple Choice

1.( TCO 7) Using the BOOK _ CUSTOMER and BOOK _ ORDER tables shown below for references, which SQL statement will return the same results as the following SQL statement?

SELECT * FROM book _ customer, book _ order;( Points: 4)

SELECT * FROM book _ order CROSS JOIN book _ customer;

SELECT * FROM book _ order, book _ customer