CIS 336 All Assignments CIS 336 All Assignments | 页面 4

Question 6. 6. (TCO 9) The column to be updated by the UPDATE command is specified in the
_____ clause.
Question 7. 7. (TCO 9) Using the promotion table shown below, which of the following SQL
statements will insert a new row into the PROMOTION table?
Question 8. 8. (TCO 10) Which of the following commands is used to establish a user account?
Question 9. 9. (TCO 10) Which command will delete a user account from Oracle9i?
Question 1. 1. (TCO 2) Explain what physical independence means.
Question 2. 2. (TCO 3) What is a composite primary key and in what situation are they most
commonly used? Give an example.
Question 3. 3. (TCO 7) Sally needs to find all employees who have a date of hire between 01-
JAN-2003 and 01-JAN-2005. She writes and executes the following query.
Question 4. 4. (TCO 8) In a table named ORDER, there is a column named SHIPDATE that
contains a date for each order that has been shipped. Write the query that would show the
number of orders that have been shipped. List the column name as Number of Orders Shipped
for this derived column.