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
DB2 11 Fundamentals for z/OS exam (Page 4 )

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

To ensure only positive values are entered into a column, you add a constraint on the SALARY column of a previously populated table. If DB2 cannot guarantee the existing values in the column are positive, it will place the table space or partition that contains the table into which of the following states?

  1. CHECK PENDING
  2. REORG PENDING
  3. REBUILD PENDING
  4. ADVISORY REORG PENDING

Answer(s): A


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/ db2z_checkpendingstatus.html



Using the SQL statement DECLARE GLOBAL TEMPORARY TABLE (DGTT) which of the following is TRUE?

  1. A DGTT is only stored in memory
  2. The qualifier for a DGTT is SESSION
  3. The DGTT can be specified in a referential constraint
  4. All privileges associated with the DGTT are stored in the DB2 catalog

Answer(s): B


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_declareglobaltemptable.html



DB2 native SQL procedures execute in which DB2 address space?

  1. IRLM
  2. DIST
  3. DBM1
  4. WLM stored procedure

Answer(s): C


Reference:

http://robertsdb2blog.blogspot.com/2012/12/db2-for-zos-clearing-up-native-sql.html



Which isolation level is described by the following?
The ISOLATION(..) option allows maximum concurrency with data integrity. Under the ISOLATION(..) option, a transaction holds locks only on its uncommitted changes and on the current row of each of its cursors.

  1. CS
  2. UR
  3. RR
  4. RS

Answer(s): A


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/perf/src/tpc/db2z_isocs.html



Why would an SQL statement receive an SQLCODE of +100? (Choose two.)

  1. The result of a SELECT INTO statement was an empty table
  2. A rowset FETCH statement encountered one or more error conditions
  3. The statement references an object that is not defined in the DB2 subsystem
  4. An error occurred during the insertion of a row into an optional explanation table
  5. A FETCH statement was executed when the cursor was positioned after the last row of the result table

Answer(s): A,B


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/codes/src/tpc/p100.html



Viewing page 4 of 26
Viewing questions 16 - 20 out of 124 questions



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

Join the C2090-320 Discussion