CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 80

(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
clause and HAVING clause similar and why you can use the
HAVING with a group function but not a WHERE clause.
=============================================
CIS 336 Week 2 Quiz (New)

FOR MORE CLASSES VISIT
www.cis336study.com

Question 1.
(TCO 1) Raw facts, such as a telephone number,
a birth date, and a customer name, are also referred to as _____