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

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?
Question 6.
(TCO 8) Based on the contents of the
BOOKS table shown below, which of the following SQL
statements will return the total profit generated by books in the
COOKING category?
Question 7.
(TCO 8) Before the COMMIT command
is used, you can retrieve deleted records by using the _____
command.
Question 8.
(TCO 8)Based on the contents of the
BOOK_ORDER table shown below, which of the following
SQL statements will list the order number and customer number
for the most recent orders in the system?