Examice

Exam 1z0-149 All QuestionsBrowse all questions from this exam

Go to Exam

Question 6

Which three are true about anonymous blocks and subprograms? (Choose three.)

Named subprograms cannot be called from other packages.

PROCEDURE subprograms can accept parameters.

A FUNCTION subprogram must return one or more values.

Anonymous blocks cannot use packaged variables.

Named subprograms are stored in the database server.

Anonymous blocks must always start with the Declare keyword.

FUNCTION subprograms must be called and passed through one or more parameters.

Correct Answer: B, E, F

PROCEDURE subprograms can accept parameters, which makes 'B' correct. Named subprograms are stored in the database server, making 'E' correct as well. Anonymous blocks can be written without the DECLARE keyword, but if they include variable declarations, the DECLARE keyword is necessary, which aligns with 'F' as being correct. While 'C' suggests a function subprogram must return one or more values, this is incorrect because a FUNCTION subprogram must return exactly one value.

Discussion

abdullah_barhamOptions: BCE

B C AND E

TheOracleWasTaken

A function cant return one or more value tho can it?

mattiamarraffa

function CAN return multiple values through OUT or INOUT parameters (like procedure)

thranduylOptions: BCE

BCE IS TRUE