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’;
Answer: D