CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 4

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.