Exam 1z0-071 topic 1 question 157 discussion

Actual exam question from Oracle's 1z0-071

Question #: 157
Topic #: 1

[All 1z0-071 Questions]

Examine this query:
SELECT SUBSTR(SYSDATE, 1, 5) "Result" FROM DUAL;

Which statement is true?

A. It fails unless the expression is modified to SUBSTR(TO_CHAR(SYSDATE), 1, 5).
B. It fails unless the expression is modified to SUBSTR(TO_CHAR(TRUNC(SYSDATE), 1, 5).
C. It fails unless the expression is modified to TO_CHAR(SUBSTR(SYSDATE), 1, 5)).
D. It executes successfully with an implicit data type conversion.

Show Suggested Answer

Suggested Answer: D 🗳️

by jfc1 at Feb. 20, 2023, 3:27 p.m.

Comments

Submit Cancel

Bissto

9 months, 1 week ago

Selected Answer: A

A. It fails unless the expression is modified to SUBSTR(TO_CHAR(SYSDATE), 1, 5). This statement is correct because the SUBSTR function needs a string as input, and SYSDATE must be converted to a string using TO_CHAR. The correct syntax would be SUBSTR(TO_CHAR(SYSDATE, 'DD-MON-YYYY'), 1, 5) if you wanted to extract the first 5 characters from the formatted date.

upvoted 1 times

2 years, 3 months ago

Selected Answer: D

select sysdate from dual; --Result : 2/20/2023 10:32:16 AM select substr(sysdate,1,5) as "xxx" from dual; --Result: 20-FE

upvoted 2 times

...