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?