Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-320

IBM C2090-320 Exam Questions
DB2 11 Fundamentals for z/OS exam (Page 4 )

Updated On: 21-Feb-2026
Page 4 of 26
PDF with 124 Questions

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

Answer(s): B



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’;

Answer(s): A



The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

  1. A view
  2. A temporal table
  3. A created global temporary table
  4. A declared global temporary table

Answer(s): B



In a unique referential constraint, which type of key does a foreign key reference?

  1. Child key
  2. Collation key
  3. Parent key
  4. Secondary key

Answer(s): C


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0020166.html



The following definition for COL1 is given by this statement: CREATE TABLE… (COL1 BINARY (05))
Which of the following statements will successfully insert data into the table?

  1. INSERT INTO… (COL1) VALUES(HEX(‘12345’));
  2. INSERT INTO… (COL1) VALUES(BLOB(‘12345’));
  3. INSERT INTO… (COL1) VALUES(CHAR(‘12345’));
  4. INSERT INTO… (COL1) VALUES(BINARY(‘123456’));

Answer(s): C






Post your Comments and Discuss IBM C2090-320 exam dumps with other Community members:

Join the C2090-320 Discussion