CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 82

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.
Question 3.
(TCO 6) Which of the following
commands will increase the size of the CITY column in the
CUSTOMERS table from 12 to 20 and increase size of the
LASTNAME column from 10 to 14?
Question 4.
(TCO 8) Based upon the contents of
the BOOKS table shown below, which of the following SQL
statements will return the number of different categories
contained in the table?