1Z0-071 Web TestEngine demo

Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

Select all that apply.

• A

  SELECT * FROM customers WHERE insert_date=DATE'2019-01-01';

• B

  SELECT * FROM customers WHERE customer_id='0001';

• C

  SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';

• D

  SELECT * FROM customers WHERE insert_date'01-JAN-19';

• E

  SELECT * FROM customers WHERE customer_id=0001;

• F

  SELECT * FROM customers WHERE TO_CHAR(customer_id)='0001';