CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 81

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
Question 1.
(TCO 8) The ____ set operator in SQL
combines rows from two queries and returns only the values that are
common between the two sets.
Question 2.
(TCO 8) Which SQL function converts a
value to a particular string format?
Question 3.
(TCO 8) Based upon the contents of the
BOOK_ORDER table shown below, which of the following SQL
statements will display only those orders shipped to the zip code zone
that begins with 323?
Question 4.
(TCO 8) Oracle‘s pseudo table used only for
cases where a table is not really needed is _____
Question 5.
(TCO 7) Using the BOOK_CUSTOMER and
BOOK_ORDER tables shown below for reference, which SQL
statement will return the first and last name of each customer who's
order has not yet shipped?
Question 6.
(TCO 7) A table alias or qualifier cannot be
assigned in the FROM clause of which type of join?