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

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?

Question 2.( TCO 9) If the _____ clause of the UPDATE command is omitted, then all the rows in the specified table will be changed.