2090
Test: Quiz: Case and Character Manipulation Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer. Case and Character Manipulation (Answer all questions in this section) 1. Identify the output from the following SQL statement: SELECT RPAD('SQL',6, '*') FROM DUAL Mark for Review (1) Points ******SQL ***SQL SQL*** (*) SQL****** Incorrect. Refer to Section 1 2. Single row functions may be used in ______, _______ and _______ clauses. (Choose two correct answers) Mark for Review (1) Points (Choose all correct answers) SELECT, FROM, ALWAYS FROM, SELECT, ORDERS WHERE, DECODE, ORDER BY (*) SELECT, WHERE, ORDER BY (*) Incorrect. Refer to Section 1 3. Which character manipulation function always returns a numerical value? Mark for Review (1) Points TRIM LPAD LENGTH (*) SUBSTR This watermark does not appear in the registered version - http://www.clicktoconvert.com
