CIS 336 All Assignments CIS 336 All Assignments | Page 60

(TCO 7) Explain the difference between an inner join and an outer join.
CIS 336 Quiz 5
Click Below Link To Purchase
www.foxtutor.com/product/cis-336-quiz-5
(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?
(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?