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?

The correct answer is A. GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION. See the full explanation below for the reasoning.

Question

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?

Options

AGRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION;
BGRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;
CGRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;
DGRANT UPDATE (title, address) ON customers TO andrew;
EGRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;
FGRANT UPDATE ON customers.title, customers.address TO andrew;

How the community answered

(44 responses)

A
73% (32)
C
2% (1)
D
5% (2)
E
14% (6)
F
7% (3)

Community Discussion

Samuel O.May 20, 2026

A is your answer, and once you understand the two moving pieces it locks in permanently. The column list goes in parentheses right after the privilege keyword, so UPDATE (title, address) is the correct syntax, which rules out D, E, and F immediately since E and F use dot notation that Oracle does not support for column-level grants. WITH GRANT OPTION is what lets the grantee pass that privilege along to others, whereas WITH ADMIN OPTION applies to system privileges, not object privileges like UPDATE on a table, so B and C are wrong on two counts each. I had to learn this distinction the hard way on a real project where someone used ADMIN OPTION on a table grant and it silently failed to cascade, so this one stuck with me.

Anjali D.Oct 18, 2025

A is the one you want here. The column list goes in parentheses right after UPDATE, the table goes in the ON clause, and WITH GRANT OPTION is what lets Andrew pass that permission along to others, since WITH ADMIN OPTION applies to system privileges, not object privileges like this one.

Priya O.Apr 24, 2026

A is the one. GRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION is the correct syntax for column-level object privileges in Oracle, and WITH GRANT OPTION is what lets the grantee turn around and grant that same privilege to someone else. WITH ADMIN OPTION is for system privileges, not object privileges, so B and C are wrong on that count alone. C, E, and F also use the wrong syntax for column-level grants, you cannot write customers.title as the object reference in a GRANT statement, the column list goes in parentheses after the privilege keyword. I actually saw this exact trap on my OCP exam years ago and I almost second-guessed myself because ADMIN OPTION sounds more powerful. What saved me was remembering the mnemonic I drilled: object privilege, GRANT option; system privilege, ADMIN option. The moment I recalled that the question was about an UPDATE on a table, which is an object privilege, the answer locked in immediately and I moved on without changing it.

Dervla O.Oct 13, 2025

I honestly looked at B first because "ADMIN OPTION" sounds like the more powerful choice when you want someone to be able to pass a privilege along, but ADMIN OPTION only applies to system privileges, not object privileges, so it can never appear in a GRANT on a table. Once I remembered that distinction, A locked in immediately, because WITH GRANT OPTION is the correct clause for delegating object privileges, and the column list syntax with parentheses is exactly how you scope UPDATE to specific columns.

Grace U.Oct 15, 2025

That column-scoping detail is the part that trips people up most on the exam, so it is worth saying plainly: you can mix broad and narrow in one statement, granting UPDATE on specific columns while granting SELECT on the whole table in the same GRANT.

Ingrid P.May 11, 2026

A is right, and the syntax trips people up constantly because column-level privileges use the column list in parentheses after the privilege keyword, not dot notation like options E and F show. Do you have a card yet for the distinction between WITH GRANT OPTION and WITH ADMIN OPTION, because those two get mixed up on this exam more than almost anything else?

Toby R.May 24, 2026

A is right. WITH GRANT OPTION, not ADMIN OPTION, and column list uses parens not dot notation.

Hiroshi T.Jun 1, 2026

I initially leaned toward B because ADMIN OPTION sounds authoritative, but then I checked the Oracle Database SQL Language Reference and it is clear that ADMIN OPTION applies to system privileges while GRANT OPTION applies to object privileges, and UPDATE on a table is an object privilege. The column-list syntax (title, address) in parentheses after the privilege name is also documented as the correct form for column-level object privileges, which rules out E and F entirely.

Grace U.Oct 9, 2025

I almost went with E because I saw WITH GRANT OPTION and thought that covered both requirements, but then I remembered that column-level object privileges have to list the columns in parentheses right after the privilege keyword, not in a table.column dot format, which is what knocked out E and F entirely and left A as the only one with both the correct syntax and the ability for Andrew to pass that privilege along.

Viktor S.Oct 22, 2025

Thought B was it, but ADMIN OPTION is for system privileges, not object privileges.

-1

Full 1Z0-071 Practice