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