Which privilege on the schema is required to add search optimization for the table?

• A. ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
• B. OWNERSHIP privilege on the schema
• C. USAGE privilege on the schema
• D. MONITOR privilege on the schema

Answer: (A)

Starting with the operation itself: enabling search optimization for a table is governed by a specific privilege that must be granted on the schema containing that table. You need the ADD SEARCH OPTIMIZATION privilege on the schema, because this feature is controlled at the schema level and allows the holder to enable optimization for any table within that schema. USAGE on the schema only permits access to objects without granting the authority to modify or enable features, so it isn’t sufficient. MONITOR is for observing activity and does not grant modification rights. OWNERSHIP would implicitly allow performing many actions, including enabling search optimization, but the question focuses on the specific privilege required to perform the action, which is ADD SEARCH OPTIMIZATION on the schema.