--------------------------------------------------------------------------------------- CIS 336 Week 6 Quiz ( New ) FOR MORE CLASSES VISIT
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 ?
Question 7 . ( TCO 7 ) A ( n ) ____ join returns not only the rows matching the join condition ( that is , rows with matching values in the common columns ) but also the rows with unmatched values .
Question 8 . in this format :
( TCO 7 ) Which statement will display the date
--------------------------------------------------------------------------------------- CIS 336 Week 6 Quiz ( New ) FOR MORE CLASSES VISIT