Oracle Exam 1Z0-071 Topic 2 Question 92 Discussion

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

Question #: 92
Topic #: 2

[All 1Z0-071 Questions]

Which three statements are true about single-row functions?

AThe data type returned can be different from the data type of the argument.

BThey can be nested to any level.

CThey return a single result row per table.

DThey can accept only one argument.

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

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

Show Suggested Answer

Suggested Answer: A, B

by Nida at May 08, 2024, 05:28 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Glenn

7 months ago

Yes, C and D don't make sense. And F is definitely false, they can be used in SELECT clauses.

upvoted 0 times

...

Nicolette

7 months ago

So, A, B, and E are the ones? C and D seem off, right?

upvoted 0 times

...

Beckie

7 months ago

Don't forget E. The argument flexibility makes it true too.

upvoted 0 times

...

Lettie

7 months ago

True, they can return different data types. And B, nesting them is also possible.

upvoted 0 times

...

Nicolette

7 months ago

Yeah, single-row functions are tricky. I believe statement A is true.

upvoted 0 times

...

Glenn

7 months ago

I think this question is a bit confusing. I'm not entirely sure.

upvoted 0 times

...