Oracle 1Z0-051 Question Answer

Where can sub queries be used? (Choose all that apply)

A. field names in the SELECT statement
B. the FROM clause in the SELECT statement
C. the HAVING clause in the SELECT statement
D. the GROUP BY clause in the SELECT statement
E. the WHERE clause in only the SELECT statement
F. the WHERE clause in SELECT as well as all DML statements

Answer: ABCF


Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

A. SELECT TO_CHAR(1890.55,'$99G999D00')
FROM DUAL;
B. SELECT TO_CHAR(1890.55,'$9,999V99')
FROM DUAL;
C. SELECT TO_CHAR(1890.55,'$0G000D00')
FROM DUAL;
Real 8
Oracle 1z0-051 Exam
D. SELECT TO_CHAR(1890.55,'$99G999D99')
FROM DUAL;
E. SELECT TO_CHAR(1890.55,'$9,999D99')
FROM DUAL;

Answer: ACD