DB2 11 Fundamentals for z/OS exam (C2090-320) - IBM Actual Exam Questions
Last updated on April 25, 2026
What is the implicitly created column in a base table which contains an XML column called?
Node ID
ROWID
LOCATOR
DOCID
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Assuming column hire date is a DATE data type, which SQL statement will retrieve the maximum salary (salary) and minimum salary(salary) for each job(job) from EMPLOYEE table for those hired(hiredate) before 1965?
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
In which address space would a native SQL stored procedure run?
WLM
DIST
DBM1
The address space of the calling program
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which of the following table space types does NOT support the use of REORG TABLESPACE SHRLEVEL(NONE)?
LOB
Simple
Partition-by-range
Partition-by-growth
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?
Create the object in a trusted context that is defined with the ROLE AS OBJECT OWNER AND QUALIFIER clause
Create the object after activating the SEPARATE_SECURITY=YES DSNZPARM
Let somebody with SYSCTRL authority create the object
Create the object after activating an audit policy that will apply to the table that you are about to create
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.