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
Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?
Options
A All held LOB locators are retained
B All rows and all logical work files of every created temporary table of the application process are deleted
C All locks that are implicitly acquired during the unit of recovery are retained
D All cursors are closed, all prepared statements are retained, and any cursors that are associated with the prepared statements are invalidated
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
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!

3
Question
The following warning message is issued when the last available active log data set is 5% full:
DSNJ110E - LAST COPY n ACTIVE LOG DATA SET IS nnn PERCENT FULL

What will happen if you ignore this message?
Options
A DB2 will shut down if it reaches the 100 % full condition
B DB2 will stop any activity that requires log writes if it reaches the 100 % full condition
C DB2 will overwrite the oldest archive log without archiving
D DB2 will automatically allocate more active log data sets as long as there are still less than 93 of them
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
In a unique referential constraint, which type of key does a foreign key reference?
Options
A Child key
B Parent key
C Collation key
D Secondary key
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
Which catalog table contains the information about definition changes for an object that have not yet been applied by the REORG utility?
Options
A SYSIBM.SYSCHECKDEP
B SYSIBM.SYSDEPENDENCIES
C SYSIBM.SYSPENDINGDDL
D SYSIBM.SYSPENDINGOBJECTS
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.