Logo ExamsQA
Exit
Official Bank 0/124

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

Last updated on June 20, 2026

97% Exam Compliance
124 Total Questions
1
Question
If a scrollable cursor is INSENSITIVE, which of the following applies?
Options
A The cursor is read only
B The select-statement must not contain an SQL data change statement
C WITH ROWSET POSITIONING is not allowed
D The cursor has sensitivity to changes that are made to the database after the result table is materialized
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
COL1 is defined as CHAR(05) and contains CHAR(‘12345’). Which of the following expressions returns the digits 12345 for further calculation?
Options
A HEX(COL1)
B PACK(COL1)
C DEC(COL1)
D DIGITS(COL1)
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
How can a user-defined function (UDF) be invoked?
Options
A Via an SQL SELECT statement
B Directly via a RUN PROGRAM command
C Via a CALL statement using SPUFI
D Via a CALL statement from within an application program
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Which of the following coupling facility structures are used by DB2 in a data sharing environment?
Options
A List structure, DB2 logs, and group buffer pools
B Lock structure, shared communications area, and group buffer pools
C Work file database, list structure, and virtual buffer pools
D Lock structure, shared communications area, and bootstrap data sets
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
C

Given the following table:

Exhibit

Which of the following INSERT statements will be successful?
Options
A INSERT INTO EMPSAMP (empno.name, salary, deptno, level,hiretype. hiredate) VALUES(2,'Mary
Smith', 35000.00, 11, 'Associate'. 'existing705-06-2016');
B INSERT INTO EMPSAMP VALUES(2,'Mary Smith', 35000.00, 11, 'Associate'. 'existing\'05-06-
2016');
C INSERT INTO EMPSAMP ('Mary Smith', 35000.00. 11, 'Associate', 'existing705-06-2016');
O
D INSERT INTO EMPSAMP (name, salary, deptno, level) VALUES('Mary Smith', 35000.00, 11,
'Associate'):
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.