CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 4

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.
Question 5. 5. (TCO 6) Write the SQL statement that will remove the database table
EMPLOYEE.
Question 1. 1. (TCO 7) Write a join query that for every order placed on September 5,
1998, (use '05-SEP-1998') will list the order number and order date along with the
customer number, last name, and first name of the customer who placed the order.