CIS 336 Final Exam (Feb 2016) CIS 336 Final Exam (Feb 2016) | Page 3

Question 6. 6. (TCO 6) When modifying the data characteristics of a column in Oracle, which of
the following is correct?
Question 7. 7. (TCO 6) Which of the following keywords can be used to change the size,
datatype, or default value of an existing column?
Question 8. 8. (TCO 7) Any type of subquery can be used in the _____ clause of a SELECT
statement
Question 1. 1. (TCO 7) Which of the following subqueries returns more than one row of results
to the outer query?
Question 2. 2. (TCO 7) To list a unique value, where the list will produce only a list of those
values that are different from one another, you will write the command _____
Question 3. 3. (TCO 8) Based upon the contents of the BOOK_ORDER table shown below, which
of the following SQL statements will display the ship date for order 1006 as April 2, 2002?
Question 4. 4. (TCO 8) Which of the following format elements will display insignificant leading
zeros?
Question 5. 5. (TCO 8) Which of the following functions determines the number of characters in
a character string?