CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Page 84

Question 2.
(TCO 7) Which of the following symbols can be
used to denote that any and all characters following the sign are
eligible when used with LIKE?
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