Oracle Database SQL — Question 228

Which two are true to create an index in your own schema for a table owned by another schema? (Choose two.)

Answer options

• A. You must have the UNLIMITED TABLESPACE privilege.
• B. You must have either the SELECT privilege on the table or the SELECT ANY TABLE privilege.
• C. You must have the CREATE ANY INDEX privilege.
• D. You have the UNLIMITED TABLESPACE privilege or sufficient quota for the tablespace to contain the index.
• E. You have either the INDEX privilege on the table or the CREATE ANY INDEX privilege.

Correct answer: C, D

Explanation

The correct answers are C and D because to create an index on a table owned by another schema, you need the CREATE ANY INDEX privilege (C) and either UNLIMITED TABLESPACE or sufficient quota for the tablespace (D). Options A, B, and E are not necessary for this specific action.