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

SELECT ROUND(21.12, 0+) FROM dual;
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;