nerdexam
Oracle

1Z0-071 · Question #329

Examine the description of the EMPLOYEES table: Which query requires explicit data type conversion?

The correct answer is A. SELECT join_date FROM employees WHERE join_date > '10-02-2018'. See the full explanation below for the reasoning.

Question

Examine the description of the EMPLOYEES table:

Which query requires explicit data type conversion?

Exhibit

1Z0-071 question #329 exhibit

Options

  • ASELECT join_date FROM employees WHERE join_date > '10-02-2018';
  • BSELECT salary + `120.50' FROM employees;
  • CSELECT SUBSTR(join_date, 1, 2) ?10 FROM employees;
  • DSELECT join_date + `20' FROM employees;
  • ESELECT join_date || || salary FROM employees;

How the community answered

(44 responses)
  • A
    82% (36)
  • B
    5% (2)
  • C
    2% (1)
  • D
    2% (1)
  • E
    9% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice