Oracle
1Z0-071 · Question #124
Which two statements are true regarding single row functions? (Choose two.)
The correct answer is B. TRUNC : can be used with NUMBER and DATE values. D. SYSDATE : returns the database server current date and time. See the full explanation below for the reasoning.
Question
Which two statements are true regarding single row functions? (Choose two.)
Options
- AMOD : returns the quotient of a division.
- BTRUNC : can be used with NUMBER and DATE values.
- CCONCAT : can be used to combine any number of values.
- DSYSDATE : returns the database server current date and time.
- EINSTR : can be used to find only the first occurrence of a character in a string.
- FTRIM : can be used to remove all the occurrences of a character from a string.
How the community answered
(53 responses)- A2% (1)
- B85% (45)
- C2% (1)
- E4% (2)
- F8% (4)
Community Discussion
No community discussion yet for this question.