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

Kenneth

1 months ago

Nah, user-defined functions in an ORDER BY clause? That's like putting a square peg in a round hole. Not gonna happen!

upvoted 0 times

Vince

9 days ago

D) They need not return any values.

upvoted 0 times

...

Lovetta

10 days ago

B) They can be executed as standalone commands.

upvoted 0 times

...

Jesse

16 days ago

A) They can be used in ORDER BY and GROUP BY clauses.

upvoted 0 times

...

Myra

1 months ago

Wait, user-defined functions in a SELECT statement? That's genius! I'm going to remember that one for the exam.

upvoted 0 times

Stefania

16 days ago

They can also be executed as standalone commands, which is pretty convenient.

upvoted 0 times

...

Dean

17 days ago

Yes, user-defined functions can definitely appear in the select list of a SELECT statement.

upvoted 0 times

...

Walton

2 months ago

Hmm, option F is definitely wrong. Functions can call other functions, not just other functions.

upvoted 0 times

Larae

29 days ago

E) They can appear in the select list of a SELECT statement.

upvoted 0 times

...

Winfred

1 months ago

B) They can be executed as standalone commands.

upvoted 0 times

...

Melinda

1 months ago

A) They can be used in ORDER BY and GROUP BY clauses.

upvoted 0 times

...

Bernardo

2 months 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

Nu

15 days ago

That's right, they can be used in ORDER BY and GROUP BY clauses as well.

upvoted 0 times

...

Toi

24 days ago

User-defined functions can definitely be executed as standalone commands.

upvoted 0 times

...

Maricela

1 months ago

User2

upvoted 0 times

...

Jacquelyne

1 months ago

User1

upvoted 0 times

...

Elina

1 months ago

Yes, that's true. They don't always need parameters to be defined.

upvoted 0 times

...

Quinn

2 months ago

I agree, user-defined functions can be defined without parameters.

upvoted 0 times

...

Alethea

2 months ago

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

upvoted 0 times

...

Jacob

2 months 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

2 months ago

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

upvoted 0 times

...

Precious

2 months ago

I think A, B, and E are true.

upvoted 0 times

...

Shannon

2 months 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

Yolande

18 days ago

E) They can appear in the select list of a SELECT statement.

upvoted 0 times

...

Emogene

21 days ago

D) They need not return any values.

upvoted 0 times

...

Norah

2 months ago

B) They can be executed as standalone commands.

upvoted 0 times

...