Which two SQL statements would execute successfully?

this is a false answer; even the choose should be two instead of highlight all including the question itself.how? is it a kind of …..;

A and B are correct.

—A Correct

select to_char(hire_date,’mon dd yyyy’) from employees
where to_char(hire_date,’mon dd yyyy’)<'jun 01 2002';

— B Correct
select to_char(hire_date) from employees
where to_char(hire_date,'mon dd yyyy')<'jun 01 2002';

—- C Wrong

select to_char(hire_date) from employees
where SUBSTR('01-JAN-2000',8);

select TO_DATE(SUBSTR(’01-JAN-2000′,8)) from dual;

— D Wrong
select to_char(hire_date) from employees
where hire_date IN (TO_DATE('JUN 01 98'), TO_DATE('JUL 01 98'));

Cleared Oracle Database 11g 1Z0-051 exam last weekend!

Scored 90%! (The passing score is 60%)

There were 64 questions in my actual 1Z0-051 test.

Many questions on SQL statements (Examine, Evaluate…etc.), Manipulating Data (Insert, Update, Delete), Using DDL Statements to Create and Manage Tables.

Also, please pay close attention to questions on Reporting Aggregated Data Using the Group Functions, Using Subqueries to Solve Queries, Creating Schema Objects, a little difficult!

I mainly learned the PassLeader 1Z0-051 dumps (http://www.passleader.com/1z0-051.html) (303q VCE and PDF), all questions were from it, and many wrong answers have been corrected in it, the most valid 1Z0-051 dumps! DO RECOMMEND!!