ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam
Go to Exam

Exam 1z0-082 topic 1 question 142 discussion

Actual exam question from Oracle's 1z0-082
Question #: 142
Topic #: 1
[All 1z0-082 Questions]

Which two statements are true about single row functions? (Choose two.)

  • A. CEIL : can be used for positive and negative numbers.
  • B. MOD : returns the remainder of a division operation.
  • C. CONCAT : can be used to combine any number of values.
  • D. FLOOR : returns the smallest integer greater than or equal to a specified number.
  • E. TRUNC : can be used only with NUMBER data types.
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️
by Dragon67 at April 5, 2023, 12:49 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
psycrotic5
7 months, 3 weeks ago
agree with nautil2, E. TRUNC: can be used only with NUMBER data types. This statement is incorrect. TRUNC can be used with both NUMBER and DATE data types. It truncates to the specified precision for numbers, and to the specified date component for dates
upvoted 1 times
...
nautil2
11 months ago
Selected Answer: AB
C – false, max 2 arguments D – false, returns biggest integer smaller than specified number E – false, can be also used with DATE datatype
upvoted 3 times
...
auwia
1 year ago
Selected Answer: AB
A and B are correct in my opinion.
upvoted 1 times
...
TECHNO_GUY
1 year, 3 months ago
AB are the correct answers
upvoted 3 times
j_tw
1 year, 3 months ago
agree that. E - can be used number and also date data type.
upvoted 2 times
...
Dragon67
1 year, 3 months ago
when are you preparing to take the exams
upvoted 1 times
...
...
Dragon67
1 year, 3 months ago
THERE ONLY 1 ANSWER WHICH IS A
upvoted 1 times
Dragon67
1 year, 3 months ago
*error it should be AB
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel