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

Updated On: 6-Apr-2026
Page 5 of 26
PDF with 124 Questions

If a scrollable cursor is INSENSITIVE, which of the following applies?

  1. The cursor is read only
  2. WITH ROWSET POSITIONING is not allowed
  3. The select-statement must not contain an SQL data change statement
  4. The cursor has sensitivity to changes that are made to the database after the result table is materialized

Answer(s): A


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/java/src/tpc/imjcc_tjvsjscr.html



You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?

  1. Bind your application with ISOLATION(UR)
  2. Bind your application with ISOLATION(CS)
  3. Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
  4. Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)

Answer(s): D


Reference:

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



Given the following CREATE VIEW statement and sample data; your login id is “ROGER”.
What will be the result for this query?

  1. 6
  2. 5
  3. 4
  4. 2

Answer(s): C



Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

  1. TRUNCATE employee;
  2. DELETE FROM employee;
  3. DELETE FROM employee WHERE…;
  4. TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;

Answer(s): B


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sql_delete.html



Which of the following is a characteristic of a stand-alone utility?

  1. It can only be executed using JCL
  2. It can only be executed by a user with SYSADM
  3. It can only be executed if no other utilities are running
  4. It can only be executed in a non-data sharing environment

Answer(s): A


Reference:

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



Viewing page 11 of 26
Viewing questions 51 - 55 out of 124 questions


C2090-320 Exam Discussions & Posts (Share your experience with others)

AI Tutor AI Tutor 👋 I’m here to help!