Oracle Exam 1Z0-071 Topic 5 Question 9 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 9
Topic #: 5

Examine this query:

SELECT SUBSTR (SYSDATE, 1, 5) ''Result '' FROM DUAL;

Which statement Is true?

AIt falls unless the expression is modified to substr (tociiar (Trunc (svsdate) ) , 1, 5).

BIt fails unless the expression is modified to to_char (Substr (sysdate, 1, 5) ) .

CIt fails unless the expression is modified to substr (to_char (sysdate) , 1, 5S).

DIt executes successfully with an implicit data type conversion.

Show Suggested Answer

Suggested Answer: D

by Elouise at May 06, 2022, 06:48 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!