CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | 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,
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?