CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Seite 77

(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?
(TCO 9) If the _________ clause of the UPDATE
command is omitted, then all the rows in the specified
table will be changed.
(TCO 9) Which of the following is not a valid SQL
command?
(TCO 9) Based on the contents of the PROMOTION table,
which of the following commands will delete only the row
for the Free Bookmark from the table?
(TCO 8) In using group functions we cannot place a group
function in a WHERE clause. Explain how the WHERE