CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | 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?