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

Adolph

10 days 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

...

Yolande

14 days ago

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

upvoted 0 times

...

Gene

21 days 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

...

Isabelle

24 days ago

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

upvoted 0 times

...

Maryann

25 days 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

26 days ago

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

upvoted 0 times

...