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

VALUES(FREEBOOK,75.01,89.99);

8.(TCO10)A____isauniquelyidentifiableobjectthatallowsagivenpersontologontothedatabase.(Points:4)

userroleprofilemanager

9.(TCO10)WhichcommandwilldeleteauseraccountfromOracle9i?(Points:4)

DELETEUSERusername;DELETEUSERusernameIDENTIFIEDBYpassword;DROPUSERusernameIDENTIFIEDBYpassword;DROPUSERusername;Page4-Essays1.(TCO2)WhatisCharacterdata?(Points:15)

2.(TCO3)Explaintheterm"secondnormalform".(Points:15)

3.(TCO7)Sallyneedstofindallemployeeswhohaveadate-of-hirebetween01-JAN-2003and01-JAN-2005.Shewritesandexecutesthefollowingquery: