Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which privileges or roles must a user have to add or remove search optimization on a table? (Select two.)
A
The MODIFY privilege on the table
B
The OWNERSHIP privilege on the table
C
A SECURITYADMIN role
D
The ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
E
The SELECT privilege on the table
