CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 12

6. (TCO 9) The column to be updated by the UPDATE command is specified in the
______ clause. (Points : 4)
UPDATE
SET
WHERE
COL
7. (TCO 9) If the INSERT INTO command is used to insert data values that violate an
existing constraint in a table, which of the following will happen. (Points : 4)
Oracle will raise an error and you will have to go update the incorrect data.
Oracle will raise an error and the entire row will be rejected.
Oracle will raise an error and the invalid piece of data will be rejected.
Oracle will raise and error and all current transactions will be rolled back.
8. (TCO 10) Which of the following commands is used to establish a user account?
(Points : 4)
CREATE NEW USER username
IDENTIFIED BY password;
CREATE USERNAME username
IDENTITY password;
CREATE USER username PASSWORD password;
CREATE USER username IDENTIFIED BY password;
9. (TCO 10) Which command will grant a system privilege to a user? (Points : 4)
GRANT systemprivilegeUSERNAME username
GRANT PRIVILEGE systemprivilegeTO username
GRANT systemprivilegeTO