IBM
C2090-610 · Question #47
Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls a package named CORPDATA.PKGA?
The correct answer is B. GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1. See the full explanation below for the reasoning.
Question
Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls a package named CORPDATA.PKGA?
Options
- AGRANT EXECUTE ON APPLICATION benefits TO user1
- BGRANT EXECUTE ON PACKAGE corpdata.pkga TO user1
- CGRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1
- DGRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1
How the community answered
(45 responses)- A4% (2)
- B73% (33)
- C7% (3)
- D16% (7)
Community Discussion
No community discussion yet for this question.