CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/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 ;