CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 79
( TCO 7) Explain the difference between an inner join and an outer join.
--------------------------------------------------------------------------------------- CIS 336 Quiz 5( Devry) FOR MORE CLASSES VISIT www. cis336study. com
( 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 7) Explain the difference between an inner join and an outer join.
--------------------------------------------------------------------------------------- CIS 336 Quiz 5( Devry) FOR MORE CLASSES VISIT www. cis336study. com
( 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?