READ Free Dumps For Oracle- 1z1-051
| Question ID 4731 | Where can sub queries be used? (Choose all that apply) |
| Option A | A. The HAVING clause in the SELECT statement |
| Option B | B. The WHERE clause in only the SELECT statement |
| Option C | C. The WHERE clause in the SELECT as well as all DML statements |
| Option D | D. The FROM clause in the SELECT statement |
| Option E | E. Field names in the SELECT statement |
| Option F | F. The GROUP BY clause in the SELECT statement |
| Correct Answer | A,C,D,E |
| Question ID 4732 | Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.) |
| Option A | A. SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL; |
| Option B | B. SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL; |
| Option C | C. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL; |
| Option D | D. SELECT TO_CHAR(1890.55,'$99G999D99') FROM DUAL; |
| Option E | E. SELECT TO_CHAR(1890.55,'$9,999D99') FROM DUAL; |
| Correct Answer | A,C,D |