CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 81
( 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
( 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