Oracle Discussions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Go to Exam

Exam 1z0-071 topic 1 question 162 discussion

Actual exam question from Oracle's 1z0-071

Question #: 162
Topic #: 1

[All 1z0-071 Questions]

Examine the description of the CUSTOMERS table:

Which two statements will do an implicit conversion? (Choose two.)

A. SELECT * FROM customers WHERE customer_id - '0001';
B. SELECT * FROM customers WHERE customer_id - 0001;
C. SELECT * FROM customers WHERE insert_date - DATE '2019-01-01';
D. SELECT * FROM customers WHERE insert_date - '01-JAN-19';
E. SELECT * FROM customers WHERE TO_CHAR(customer_id) - '0001';

Show Suggested Answer

Suggested Answer: AD 🗳️

by tonII20II at March 11, 2023, 1 p.m.

Comments

Submit Cancel

yaya32

12 months ago

Selected Answer: AD

I think AD is correct

upvoted 2 times

...

Arth1989

1 year ago

Tested twice. AC

upvoted 1 times

...

jm9999

1 year, 3 months ago

Selected Answer: AD

No error for me on D, worked fine.

upvoted 1 times

...

XTIMON

1 year, 4 months ago

Selected Answer: AD

A D are correct

upvoted 2 times

...

zouve

1 year, 6 months ago

Selected Answer: AC

D i am getting an error ORA-01722: invalid number

upvoted 1 times

...

Orxan_H

1 year, 6 months ago

Selected Answer: AD

A D are correct

upvoted 2 times

...

Darnun

1 year, 9 months ago

Not sure about this one - A, B, E compile successfully and got the same results for all of them. C is not an implicit conversion, D throws an error 'invalid NUMBER'.

upvoted 1 times

Darnun

1 year, 9 months ago

Forget about it, tonII20II is right - AD must be right. C,E are not implicit conversions, in B both are numbers.

upvoted 1 times

...

tonII20II

1 year, 10 months ago

AD must be correct. C is not an implicit conversion

upvoted 3 times

...