Exam 1z0-144 topic 1 question 101 discussion

Actual exam question from Oracle's 1z0-144

Question #: 101
Topic #: 1

[All 1z0-144 Questions]

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

A. Only subprograms can be parameterized.
B. Only subprograms are persistent database objects.
C. Both anonymous blocks and subprograms can be parameterized.
D. Both anonymous blocks and subprograms are persistent database objects.
E. Only subprograms can return values that persist after the execution of the subprogram.
F. Both anonymous blocks and subprograms can return values that persist in SQL*Plus variables after their execution.

Show Suggested Answer

Suggested Answer: BCF 🗳️

by chamisso at Jan. 16, 2020, 8:14 a.m.

Comments

Submit Cancel

chamisso

Highly Voted 5 years, 4 months ago

ABE is correct answer

upvoted 8 times

nadzeya_bdc

4 years, 10 months ago

Thank you, I think the same.

upvoted 1 times

Gianluca1988

4 years, 4 months ago

CF ARE CORRECT ANSWERS I THINK BECAUSE OF BIND VARIABLES

upvoted 1 times

...

BM2000

Most Recent 2 years, 3 months ago

Selected Answer: ABF

var x number; var y number; begin :x :=1; end; create or replace function f3 return number is begin return 2; end; exec :y := f3(); print x; - - 1 print y; - - 2

upvoted 1 times

...