IBM
C2090-320 · Question #81
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with "CREATE…
The correct answer is A. SET CURRENT SQLID = `DB2'. See the full explanation below for the reasoning.
Question
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with "CREATE INDEX AAA ON...". Which of the following statements must precede the CREATE statement so that you can create the index?
Options
- ASET CURRENT SQLID = `DB2';
- BSET CURRENT RULES = `DB2';
- CNo preceding statement is needed
- DSET CURRENT SCHEMA = `DB2';
How the community answered
(47 responses)- A72% (34)
- B9% (4)
- C15% (7)
- D4% (2)
Community Discussion
No community discussion yet for this question.