CIS 336 STUDY Extraordinary Life/cis336study.com CIS 336 STUDY Extraordinary Life/cis336study.com | Page 13

5 . ( TCO 8 ) Which of the following statements will produce the value 21.1 ? ( Points : 4 )

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