CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 3

Question 5. 5. (TCO 8) Which of the following functions determines
the number of characters in a character string?
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.
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