Oracle Exam 1Z0-071 Topic 15 Question 101 Discussion

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

Question #: 101
Topic #: 15

[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 Mozell at Sep 07, 2024, 05:20 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sabra

2 months ago

You're right, they can be used in the SELECT list, ORDER BY, and HAVING clauses as well.

upvoted 0 times

...

Gabriele

2 months ago

But single-row functions can be used in other parts of a SELECT statement too.

upvoted 0 times

...

Teri

2 months ago

I disagree, I believe F is also true.

upvoted 0 times

...

Cassi

2 months ago

I'd go with A, B, and E. Those seem like the clear winners to me. D and F are just silly - single-row functions can have multiple arguments and can be used in various clauses, not just WHERE.

upvoted 0 times

Brett

1 months ago

Yeah, A, B, and E are the ones that make sense. D and F are definitely incorrect.

upvoted 0 times

...

Rosendo

1 months ago

A, B, and E make the most sense to me too. D and F are definitely not true.

upvoted 0 times

...

Evelynn

2 months ago

I think A, B, and E are the correct choices as well. D and F don't seem right.

upvoted 0 times

...

Cory

2 months ago

I agree, A, B, and E are definitely true. D and F are misleading.

upvoted 0 times

...

Bette

3 months ago

Haha, F is just ridiculous. Of course single-row functions can be used in more places than just the WHERE clause. These answer options are a bit all over the place.

upvoted 0 times

Madalyn

2 months ago

I think C is also true, single-row functions do return a single result row per table.

upvoted 0 times

...

Adela

2 months ago

Yeah, these answer options are confusing. A, B, and E seem more accurate.

upvoted 0 times

...

Ellsworth

2 months ago

I agree, F is definitely not true. Single-row functions can be used in many places.

upvoted 0 times

...

Taryn

3 months ago

I agree with Fatima. B and E are definitely correct. But I'm not sure about C - I think single-row functions can return multiple rows per table.

upvoted 0 times

Cordie

2 months ago

I think C is incorrect. Single-row functions return a single result row per table.

upvoted 0 times

...

Cordie

2 months ago

B and E are correct. Single-row functions can be nested to any level and the argument can be a column name, variable, literal, or an expression.

upvoted 0 times

...

Sabra

3 months ago

I think B and D are also true.

upvoted 0 times

...

Gabriele

3 months ago

A, C, E are true.

upvoted 0 times

...

Fatima

3 months ago

A, B, and E are definitely true. Single-row functions can return different data types and can be nested. The arguments can be various forms, not just one.

upvoted 0 times

Earleen

3 months ago

Yes, single-row functions can return different data types and can be nested.

upvoted 0 times

...

Ailene

3 months ago

I agree, A, B, and E are definitely true.

upvoted 0 times

...