CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your 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.