database:

1.

2.

3.

4.

5.

The Oracle function returns a string in all capital letters. Select one: O a. UPPER() b. LENGTH() O c. SUBSTR() d. LOWER() The Oracle function rounds a value to a specified precision Select one: a. CEIL) b. FLOOR() O c. ABS() O d. ROUND() The Oracle function converts a date to a character string. Select one: O a. TO_CHAR() O b. TO_STRING() C. TO_DATE() O d. CONVERT(). The syntax for a left outer join is Select one: a. SELECT column-list FROM table1 LEFT table2 [JOIN] WHERE join-condition; O b. SELECT column-list FROM table1 OUTER JOIN table2 LEFT WHERE join-condition; C. SELECT column-list FROM table1 LEFT OUTER] JOIN table2 ON join-condition; d. SELECT column-list WHERE LEFT table1 = table; When using a(n) join, only rows from the tables that match on a common value are returned. Select one: a. outer b. set O c. inner d. full