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 .