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

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

What is the purpose of an auxiliary table?

  1. To hold the data for a column that is defined in a base table
  2. To hold only XML data
  3. To hold data temporarily
  4. To store rows that are deleted from another table

Answer(s): A


Reference:

https://help.sap.com/doc/saphelp_pd1655_data/16.5.5/en-US/c7/ cbf3e96e1b1014a434a1a425666017/content.htm?no_cache=true



Which of the following SELECT statements returns a different data value than the other SQL statements?

  1. SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
  2. SELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
  3. SELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENT TIMESTAMP(10)),6,2),’0’),11,’’) FROM SYSIBM.SYSDUMMY1;
  4. SELECT TIMESTAMPDIFF(64, CHAR(CURRENT TIMESTAMP – TIMESTAMP(‘2016-01-01-00.00.00’))) FROM SYSIBM.SYSDUMMY1;

Answer(s): D



Which command displays the DB2 catalog level and migration mode?

  1. DSNC DISPLAY
  2. MODIFY irImproc, STATUS
  3. –DISPLAY GROUP DETAIL
  4. –DISPLAY DATABASE (DSNDB06)

Answer(s): C



Which of the following effectively and efficiently manages priorities of a mixed workload as a result of its tight integration with DB2 for z/OS?

  1. Data Facility Storage Management
  2. z/OS Parallel Sysplex Configuration
  3. Workload Manager
  4. z Systems Processor Resource

Answer(s): B


Reference:

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



Which of the following coupling facility structures are used by DB2 in a data sharing environment?

  1. List structure, DB2 logs, and group buffer pools
  2. Work file database, list structure, and virtual buffer pools
  3. Lock structure, shared communications area, and group buffer pools
  4. Lock structure, shared communications area, and bootstrap data sets

Answer(s): C


Reference:

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&ved=2ahUKEwikgLDR- 8PjAhXVShUIHRDyAjMQFjACegQIBBAC&url=https%3A%2F%2Fshare.confex.com%2Fshare%2F116% 2Fwebprogram%2FHandout%2FSession8629% 2FSetting_up_DB2_data_sharing_the_easy_way.pdf&usg=AOvVaw3ltuSTxQJGT7jqxb8ZY-aq (15)



Viewing page 13 of 26
Viewing questions 61 - 65 out of 124 questions



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

Join the C2090-320 Discussion