CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | 页面 3
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?
Question 6. 6. (TCO 9) The column to be updated by the UPDATE command is specified
in the _____ clause.