CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 19

WHERE o.customer# = c.customer#;
2. (TCO 7) If a Cartesian join is used to link table A which contains five rows to table B
which contains eight rows, there will be _______ rows in the results. (Points : 4)
8
13
5
40
3. (TCO 8) Based upon the contents of the BOOK_ORDER table shown below, which of
the following SQL statements will display the ship date for order 1006 as April 2, 2002?
(Points : 4)
SELECT order#, TO_CHAR(shipdate, 'fmMonth DD, YYYY')
FROM book_order;
SELECT order#, TO_DATE(shipdate, 'fmMonth DD, YYYY')
FROM book_order;
SELECT order#, TO_CHAR(shipdate, 'Month DD, YYYY')
FROM book_order;
SELECT order#, TO_DATE(shipdate, 'Month DD, YYYY')
FROM book_order;
4. (TCO 8) Based upon the contents of the BOOK_ORDER table shown below, which of
the following SQL statements will display only those orders shipped to the zip code zone
that begins with 323?
(Points : 4)
SELECT order#, SUBSTR(shipzip, 1, 323)
FROM book_order;