Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 156

Examine the description of the CUSTOMERS table:

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

SELECT * FROM customers WHERE customer_id - '0001';

SELECT * FROM customers WHERE customer_id - 0001;

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

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

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

Correct Answer: A, D

In the query 'SELECT * FROM customers WHERE customer_id - '0001';', the expression 'customer_id - '0001'' involves subtracting a string from a number, which the database implicitly converts the string '0001' to a number. In the query 'SELECT * FROM customers WHERE insert_date - '01-JAN-19';', '01-JAN-19' is a string representation of a date, so the database implicitly converts it to a DATE type to perform the subtraction operation with the 'insert_date' column.

Discussion

tonII20IIOptions: AD

AD must be correct. C is not an implicit conversion

yaya32Options: AD

I think AD is correct

XTIMONOptions: AD

A D are correct

Orxan_HOptions: AD

A D are correct

Arth1989Options: AC

Tested twice. AC

jm9999Options: AD

No error for me on D, worked fine.

zouveOptions: AC

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

DarnunOptions: AB

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'.

Darnun

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