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

DELETE USER username IDENTIFIED BY password;
DROP USER username IDENTIFIED BY password;
DROP USER username;
Page 4 - Essays
1. (TCO 2) What is Character data? (Points : 15)
2. (TCO 3) Explain the term "second normal form". (Points
: 15)
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:
4. (TCO 8) In using group functions we cannot place a group
function in a WHERE clause. Explain how the WHERE
clause and HAVING clause are similar and why you can use
the HAVING with a group function but not a WHERE
clause. (Points : 15)
5. (TCO 6) Write the SQL statement that will remove the
database table EMPLOYEE. (Points : 15)
1. (TCO 7) Write a join query using NATURAL JOIN that
for every order in the ORDERS table will list the order
number and order date along with the cusnumber, last
name, and first name of the customer who placed the order.
2. (TCO 8) Write a query that will list the part number, part
description, and on-hand value (units on hand * unit price)