CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 2

Question 1. 1. (TCO 4) When creating a table, which of the
following statements is NOT correct?
Question 2. 2. (TCO 4) Which of the following SQL statements
would you use to create a table named DEVRY?
Question 3. 3. (TCO 5) The Crow's Foot model is more _____-
oriented than the Chen model.
Question 4. 4. (TCO 5) Knowing the _____ number of entity
occurrences is very helpful at the application software level.
Question 5. 5. (TCO 6) The _____ statement can be used to enable
or disable a constraint.
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?