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

CIS 336 Quiz 5 (Devry)

FOR MORE CLASSES VISIT
www.cis336study.com
(TCO 6) Which of the following keywords is used to remove
a row in a table?
(TCO 6) When using the ALTER TABLE...DROP
COLUMN command, which of the following is NOT
correct?
(TCO 6) Which of the following commands will add a new
column named FIRSTORDERDATE to the CUSTOMERS
table to store the date that the customer first placed an order
with the company?
(TCO 8) Which of the following is NOT a valid statement?
(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?
(TCO 8) Which comparison operator evaluates a subquery
and if it returns false, will not execute the calling query?
(TCO 8) The following SQL statement contains which type
of subquery?