IBM C2090-600 - IBM DB2 11.1 DBA for LUW Exam
Page: 2 / 12
Total 60 questions
Question #6 (Topic: )
Which statement about the db2move command is TRUE?
A. The LOAD actions can be run from a client machine.
B. Object ownership cannot be changed after a successful schema copy operation.
C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
D. Loading data into tables containing XML columns is only supported for the LOAD actions.
Answer: D
Question #7 (Topic: )
You suspect there is a communications issue between a member and a cluster caching
facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic
information that can be used to confirm your suspicions?
facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic
information that can be used to confirm your suspicions?
A. db2cluster -verify
B. db2cluster -cm -list -alert
C. db2cluster -verify -configuration
D. db2cluster -cm -verify -resource
Answer: D
Question #8 (Topic: )
Which statement about label-based access control (LBAC) is TRUE?
A. LBAC protection can be applied to a nickname
B. LBAC cannot be used to restrict access to a staging table
C. LBAC cannot be used to restrict access to data of columns and rows in the same table
D. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type
Answer: D
Question #9 (Topic: )
Which options are valid for an online reorganization operation?
A. FULL and RECLAIM EXTENTS
B. CLASSIC and RECLAIM EXTENTS
C. FULL and CLEANUP OVERFLOWS
D. CLEAN OVERFLOWS and RECLAIM EXTENTS
Answer: A
Question #10 (Topic: )
What does dsmtop use to gather metrics?
A. db2pd
B. db2dart
C. the system catalog
D. monitoring tablefunctions
Answer: D
