Oracle Database SQL — Question 5

You need to allow user ANDREW to:
1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table.
2. GRANT that permission to other users.
Which statement will do this?

Answer options

• A. GRANT UPDATE ON customers.title, customers.address TO andrew;
• B. GRANT UPDATE (title, address) ON customers TO andrew;
• C. GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION;
• D. GRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;
• E. GRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;
• F. GRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;

Correct answer: C

Explanation

The correct answer, C, allows ANDREW to update the TITLE and ADDRESS columns and grants the ability to pass that permission to others. Options A and D do not include the ability to grant permissions to other users, while options B and F do not specify the necessary grant option. Option E is incorrect as it grants permissions without specifying the necessary context of the columns.