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
Which BIND option determines when DB2 will do authorization checking?
Options
A DEFER
B VALIDATE
C DEPLOY
D CURRENTDATA
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

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

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

5
Question
To ensure only positive values are entered into a column, you add a constraint on the SALARY column of a previously populated table If D32 cannot guarantee the existing values in the column are positive, it will place the table space or partition that contains the table into which of the following states?
Options
A CHECK PENDING
B REBUILD PENDING
C REORG PENDING
D ADVISORY REORG PENDING
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.