CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 90

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?
===================================================