CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 21

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
WHERE book _ order . customer # = book _ customer . customer #;
SELECT * FROM book _ order , book _ customer
WHERE book _ order . customer # > book _ customer . customer #;

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

WHERE book _ order . customer # = book _ customer . customer #;

SELECT * FROM book _ order , book _ customer

WHERE book _ order . customer # > book _ customer . customer #;