IBM Exam C2090-320 Topic 6 Question 1 Discussion

Actual exam question for IBM's C2090-320 exam

Question #: 1
Topic #: 6

[All C2090-320 Questions]

Your current authorization ID is DB

AOnly 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?

ASET CURRENT SQLID = 'DB2';

BSET CURRENT RULES = 'DB2';

CNo preceding statement is needed

DSET CURRENT SCHEMA = 'DB2';

Show Suggested Answer

Suggested Answer: A, A

by Cordelia at May 09, 2022, 11:53 AM

Limited Time Offer

25%

Off

Get Premium C2090-320 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!