Question

Which of the following is the system privilege that empowers the grantee to create an index in his or her own user account but not in the accounts of others?

Answer 1

A. Create Table

Step-by-step explanation:

First, the multiple options for the question:

A. CREATE TABLE

B. CREATE ANY TABLE

C. CREATE INDEX

D. CREATE ANY INDEX

In database or spreadsheet programming management among others, the create table function not only allows one to create a table but also creates an index as a privilege. This done as a result of the fact that a create table function or statement could include either a unique constraint or a primary key.

The creation of this unique constraint or primary key will automatically led to an index being created to support the primary key or the unique constraint. The create table statement also only works within the grantee's own account and not in the account of others.