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

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 course tutorials visit
www.uophelp.com
CIS 336 Week 5 Quiz
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.
string format?
(TCO 8) Which SQL function converts a value to a particular