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 3 )

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

Which option is used with the RECOVER utility when the data sets of the target objects have already been restored to a point of consistency by another process offline?

  1. LOGONLY
  2. FROMDUMP
  3. TOLASTCOPY
  4. CURRENTCOPYONLY

Answer(s): A


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/ugref/src/tpc/ db2z_recoversyntax.html



Which job generates the subsystem parameter module?

  1. DSNTIJIN
  2. DSNTIJID
  3. DSNTIJUZ
  4. DSNTIJEN

Answer(s): C


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/db2z_zparm.html



Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would provide the locking you need with optimistic locking?

  1. ISOLATION(UR)
  2. ISOLATION(RS)
  3. ISOLATION(CS) CURRENTDATA(NO)
  4. ISOLATION(CS) CURRENTDATA(YES)

Answer(s): D


Reference:

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



Given the following table:



Which of the following INSERT statements will be successful?

  1. INSERT INTO EMPSAMP (empno, name, salary, deptno, level, hiretype, hiredate) VALUES(2,’Mary Smith’, 35000.00, 11, ‘Associate’, ‘existing’,’05-06-2016’);
  2. INSERT INTO EMPSAMP (‘Mary Smith’, 35000.00, 11, ‘Associate’, ‘existing’,’05-06-2016’);
  3. INSERT INTO EMPSAMP VALUES(2,’Mary Smith’, 35000.00, 11, ‘Associate’, ‘existing’,’05-06-2016’);
  4. INSERT INTO EMPSAMP (name, salary, deptno, level) VALUES(‘Mary Smith’, 35000.00, 11, ‘Associate’);

Answer(s): A



For a partition-by-range table, which data types can be used to define the key columns that are used to partition the data? (Choose two.)

  1. XML
  2. BINARY
  3. DECIMAL
  4. VARCHAR
  5. DECFLOAT

Answer(s): C,D



Viewing page 3 of 26
Viewing questions 11 - 15 out of 124 questions



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

Join the C2090-320 Discussion