C2090-320

C2090-320 practice questions, page 3 of 3, with answer review and explanations.

Question 11

Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

  1. SQLCA
  2. SQLDA
  3. SQLCODE
  4. SQLSTATE

Question 12

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?

  1. SET CURRENT SQLID = "˜DB2';
  2. SET CURRENT RULES = "˜DB2';
  3. No preceding statement is needed
  4. SET CURRENT SCHEMA = "˜DB2';