nerdexam
Oracle

1Z0-147 · Question #44

You want to create procedures, functions and packages. Which privilege do you need?

The correct answer is D. D. CREATE PROCEDURE system privilege. See the full explanation below for the reasoning.

Question

You want to create procedures, functions and packages. Which privilege do you need?

Options

  • AA. EXECUTE CODE object privilege
  • BB. CREATE ANY CODE object privilege
  • CC. CREATE PACKAGE system privilege
  • DD. CREATE PROCEDURE system privilege
  • EE. CREATE FUNCTION, CREATE PROCEDURE, CREATE PACKAGE system privileges

How the community answered

(46 responses)
  • A
    2% (1)
  • B
    4% (2)
  • C
    7% (3)
  • D
    76% (35)
  • E
    11% (5)

Community Discussion

No community discussion yet for this question.

Full 1Z0-147 Practice