CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | 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 and order date along with the customer number, last name,
and first name of the customer who placed the order.