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

• A. OWNERSHIP privilege on the table
• B. ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
• C. ACCOUNTADMIN privilege
• D. ALL OF THE ABOVE

Answer: (A)

Enabling search optimization changes a table’s metadata, which is controlled at the object level. The ability to alter such properties is granted by owning the table. The OWNERSHIP privilege on the table lets you fully control the object, including turning on or off features like search optimization. Schema-level privileges don’t authorize modifications to a specific table’s configuration, and while a highly privileged role (like ACCOUNTADMIN) can perform the action, the question focuses on the specific table-level privilege needed. So, owning the table is the required permission to add search optimization.