Oracle Exam 1Z0-082 Topic 1 Question 111 Discussion

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

Question #: 111
Topic #: 1

[All 1Z0-082 Questions]

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

AThey can be used only in the WHERE clause of a SELECT statement

BThe argument can be a column name, variable, literal or an expression

CThe data type returned can be different from the data type of the argument

DThey can be nested to any level

EThey can accept only one argument

FThey return a single result row per table

Show Suggested Answer

Suggested Answer: A

by Rolande at Jan 23, 2025, 02:18 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

20 days ago

Wait, is there a single-row function that can do my taxes for me? If so, I'm picking that one!

upvoted 0 times

...

29 days ago

I'm going to go with B, C, and F. Single-row functions give you one result row per table, so that has to be true too.

upvoted 0 times

...

1 months ago

E is a trap answer, right? Single-row functions can take multiple arguments. B, C, and D are the way to go.

upvoted 0 times

3 days ago

C) The data type returned can be different from the data type of the argument

upvoted 0 times

...

19 days ago

B) The argument can be a column name, variable, literal or an expression

upvoted 0 times

...

2 months ago

I think B is true because single-row functions can take different types of arguments.

upvoted 0 times

...