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

www.uophelp.com
CIS 336 Week 6 Quiz
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?
Question 5.
(TCO 9) Which of the following is not a valid SQL command?