CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 84

statements will display only those orders shipped to the zip code zone
that begins with 323?
Question 4.
(TCO 8) Oracle‘s pseudo table used only for
cases where a table is not really needed is _____
Question 5.
(TCO 7) Using the BOOK_CUSTOMER and
BOOK_ORDER tables shown below for reference, which SQL
statement will return the first and last name of each customer who's
order has not yet shipped?
Question 6.
(TCO 7) A table alias or qualifier cannot be
assigned in the FROM clause of which type of join?
Question 7.
(TCO 7) A(n) ____ join returns not only the
rows matching the join condition (that is, rows with matching values
in the common columns) but also the rows with unmatched values.
Question 8.
in this format:

(TCO 7) Which statement will display the date

------------------------------------------------------------------------------

CIS 336 Week 6 Quiz (New)

FOR MORE CLASSES VISIT
www.cis336study.com
Question 1.
(TCO 6) Which of the following
keywords can be used to change the size, datatype, or default
value of an existing column?