Want to pass your DB2 11 Fundamentals for z/OS C2090-320 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Which of the following statements about a table with a LOB column is TRUE?
A. It doesn't need an auxiliary table if it has an inline LOB
B. It must also have a ROWID column and an auxiliary table
C. It doesn't need a ROWID column (implicit or explicit) if a LOB locator will be used
D. It must be in a partitioned by growth (PBG) universal table space with a ROWID column
Which authorizations can change the value of the subsystem parameter SYSADM using the -SET SYSPARM command? (Choose two.)
A. SYSADM
B. SECADM
C. SYSCTRL
D. Installation SYSADM
E. Installation SYSOPR
When the following SQL statement is executed, the user SMITH is able to manage all objects in the DB2 subsystem except for which of the following?
GRANT DBADM ON SYSTEM TO smith;
A. Tables
B. Traces
C. Sequences
D. Security Objects