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 ?