Why would you develop an SQL procedure instead of a function? Note: There are 3 correct answers to this question.

The correct answer is A. You want to create a dynamic analytic privilege. B. A temporary table must be created within the code. D. The code should modify data in a table. See the full explanation below for the reasoning.

Question

Options

AYou want to create a dynamic analytic privilege.
BA temporary table must be created within the code.
COptimal performance is a priority.
DThe code should modify data in a table.
EYou need to use conditional logic.

How the community answered

(27 responses)

A
70% (19)
C
11% (3)
E
19% (5)

Community Discussion

No community discussion yet for this question.

Full C_HANAIMP_18 Practice