CIS 336 All Assignments CIS 336 All Assignments | Page 20

6. (TCO 9) Which of the following is not a valid SQL command? (Points : 4)
UPDATE acctmanager SET WHERE ;
UPDATE acctmanager SET (amname);
UPDATE acctmanager SET (amname) WHERE ;
UPDATE acctmanager WHERE ;
7. (TCO 9) Using the promotion table shown below, which of the following SQL statements will
insert a new row into the PROMOTION table?
(Points : 4)
INSERT INTO promotion (gift, minretail, maxretail)
VALUES (FREE BOOK, 75.01, 89.99);
INSERT INTO promotion (gift, minretail, maxretail)
VALUES ('FREE BOOK', 75.01, 89.99);
INSERT INTO promotion VALUES (FREE BOOK, 75.01, 89.99);
INSERT INTO promotion (gift, minretail)
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;