Oracle Exam 1Z0-149 Topic 7 Question 47 Discussion

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

Question #: 47
Topic #: 7

[All 1Z0-149 Questions]

Which three are true about user-defined functions? (Choose three.)

AThey can be used in ORDER BY and GROUP BY clauses.

BThey can be executed as standalone commands.

CThey must be defined with at least one parameter.

DThey need not return any values.

EThey can appear in the select list of a SELECT statement.

FFunctions can call only other functions.

GThey can be used in CONNECT BY and START WITH clauses.

Show Suggested Answer

Suggested Answer: B

by Miesha at Mar 04, 2025, 12:55 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Bernardo

10 days ago

I think option C is incorrect. User-defined functions don't always need to have parameters. They can be defined without any parameters as well.

upvoted 0 times

...

Alethea

12 days ago

I'm not sure about C. Do user-defined functions really need to have at least one parameter?

upvoted 0 times

...

Jacob

14 days ago

I'm not sure about option G. Can user-defined functions really be used in CONNECT BY and START WITH clauses? That seems a bit unusual.

upvoted 0 times

...

Tiara

16 days ago

I agree with Precious. Functions can definitely be used in ORDER BY and GROUP BY clauses.

upvoted 0 times

...

Precious

18 days ago

I think A, B, and E are true.

upvoted 0 times

...

Shannon

18 days ago

Options B, D, and E seem to be the correct answers. User-defined functions can be executed as standalone commands, don't necessarily need to return values, and can appear in the SELECT list.

upvoted 0 times

Norah

6 days ago

B) They can be executed as standalone commands.

upvoted 0 times

...