IBM InfoSphere DataStage v11.5 — Question 2

Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed?
GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;

Answer options

• A. BIND
• B. REORG
• C. TRIGGER
• D. EXECUTE

Correct answer: D

Explanation

The correct answer is D, EXECUTE, because granting ALL privileges with the GRANT OPTION allows smith to pass on all permissions associated with the emp table, including EXECUTE. The other options, BIND, REORG, and TRIGGER, are not typically associated with the ALL privilege in this context and therefore cannot be granted by smith.