CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 66

www.uophelp.com CIS 336 Week 4 Quiz Question 1. (TCO 7) Which of the following types of columns will automatically right-align the data when it is displayed? 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.