CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 25

VALUES ( FREE BOOK , 75.01 , 89.99 );

8 . ( TCO 10 ) A ____ is a uniquely identifiable object that allows a given person to log on to the database . ( Points : 4 )

user role profile manager

9 . ( TCO 10 ) Which command will delete a user account from Oracle9i ? ( Points : 4 )

DELETE USER username ; 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 :

VALUES ( FREE BOOK , 75.01 , 89.99 );

8 . ( TCO 10 ) A ____ is a uniquely identifiable object that allows a given person to log on to the database . ( Points : 4 )

user role profile manager

9 . ( TCO 10 ) Which command will delete a user account from Oracle9i ? ( Points : 4 )

DELETE USER username ; 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 :