( 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
( 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 _____