IBM
C2090-320 · Question #44
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 correct answer is D. SET CURRENT SCHEMA = `DB2'. See the full explanation below for the reasoning.
Question
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?
Options
- ASET CURRENT PATH = `DB2';
- BSET CURRENT RULES = `DB2';
- CNo preceding statement is needed
- DSET CURRENT SCHEMA = `DB2';
How the community answered
(54 responses)- A4% (2)
- B2% (1)
- C9% (5)
- D85% (46)
Community Discussion
No community discussion yet for this question.