CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 83

Question 3.( TCO 7) Based upon the contents of the BOOKS table shown below, which of the following is a valid SQL statement?

Question 4.( TCO 7) Which of the following operators would be most appropriate to determine whether or not the retail price of a book is at least $ 24.00?

Question 5.( TCO 7) Based upon the contents of the BOOK _ ORDER table shown below, which of the following SQL statements will list all orders placed by customer # 1020 that have not yet been shipped?

Question 6.( TCO 7) Based upon the contents of the BOOK _ ORDER table shown below, which of the following queries will display all orders shipped between April 4, 2003 and April 5, 2003?

Question 7.(( TCO 7) The ____ comparison operator is used to search for values that are not NULL.

Question 8.( TCO 7) You want to write a SQL query that lists all employees in the EMP table whose last names in the EMP _ LNAME column start with Smith, including values such as Smithfield. What is the correct statement?

--------------------------------------------------------------------------------------- CIS 336 Week 5 Quiz( New) FOR MORE CLASSES VISIT www. cis336study. com