Which of the following statements must precede the DROP statement so that it drops the index?

Your current authorization ID is DBA. Only one of your secondary IDs, DB2, has the privilege to drop an existing index DB2.AAA on a table. The appropriate SQL statement is “DROP INDEX AAA”.

Which of the following statements must precede the DROP statement so that it drops the index?

A. SET CURRENT PATH = ‘DB2’;

B. SET CURRENT RULES = ‘DB2’;

C. No preceding statement is needed

D. SET CURRENT SCHEMA = ‘DB2’;

View Answer

Answer: D