Oracle Exam 1Z0-149 Topic 2 Question 23 Discussion

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

Question #: 23
Topic #: 2

[All 1Z0-149 Questions]

Which three are true about functions and procedures? (Choose three.)

AThe ACCESSIBLE BY clause can be used only for procedures.

BIn a function, every execution path must lead to a RETURN statement.

CBoth can have only constants as actual parameters for IN mode parameters.

DBoth can be invoked from within SQL statements.

EIn a procedure the RETURN statement cannot specify an expression.

FIn a function every RETURN statement must specify an expression.

Show Suggested Answer

Suggested Answer: A, E

by Meaghan at Apr 12, 2024, 06:09 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Mattie

1 months ago

Functions and procedures, the dynamic duo of programming. Just don't mix them up, or you might end up with a 'procedure not found' error. Am I right, or am I right?

upvoted 0 times

...

Lavonna

2 months ago

Ah, the age-old battle of functions vs. procedures. I'll go with B, D, and F. May the code be with you, fellow candidates!

upvoted 0 times

Reta

8 days ago

User 3

upvoted 0 times

...

Tarra

27 days ago

User 2

upvoted 0 times

...

Virgina

1 months ago

User 1

upvoted 0 times

...

Adolph

2 months ago

Hmm, this is tricky. I'm going to guess B, D, and F. Who comes up with these exam questions anyway? They're trying to trick us!

upvoted 0 times

Brock

27 days ago

User1: These questions are definitely tricky, but we got this!

upvoted 0 times

...

Lynelle

1 months ago

User3: F is correct too, every return in a function needs an expression.

upvoted 0 times

...

Miss

2 months ago

User2: I agree, D is also true, both can be used in SQL statements.

upvoted 0 times

...

Deandrea

2 months ago

User1: I think B is correct, every path must have a return statement.

upvoted 0 times

...

Yolande

2 months ago

C and E sound a bit off to me. I think I'll go with B, D, and F.

upvoted 0 times

Cordie

1 months ago

I'm not sure about C and E either. B, D, and F seem more accurate.

upvoted 0 times

...

Clay

1 months ago

I agree, B, D, and F are the correct choices.

upvoted 0 times

...

Gene

2 months ago

B and F are definitely true, but I'm not sure about the other options. I better review my notes on functions and procedures.

upvoted 0 times

Luz

20 days ago

Yes, that's correct. Functions and procedures can have variables as actual parameters.

upvoted 0 times

...

Vallie

1 months ago

C is false too, functions and procedures can have variables as actual parameters.

upvoted 0 times

...

Lewis

1 months ago

You're right, A is false. Functions and procedures can both have the ACCESSIBLE BY clause.

upvoted 0 times

...

Carman

2 months ago

I think A is false because the ACCESSIBLE BY clause can also be used for functions.

upvoted 0 times

...

Isabelle

3 months ago

I believe F is true as well. In a function, the RETURN statement must always specify an expression.

upvoted 0 times

...

Maryann

3 months ago

I agree with you, Ernest. I also think D is true because both functions and procedures can be called from SQL statements.

upvoted 0 times

...

Ernest

3 months ago

I think B is true because a function must always return a value.

upvoted 0 times

...