Which statement about label-based access control (LBAC) is TRUE?

LBAC protection can be applied to a nickname
LBAC cannot be used to restrict access to a staging table
LBAC cannot be used to restrict access to data of columns and rows in the same table
LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

Answer(s): D

https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.sec.doc/doc/c0021495.html (protecting rows)

Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

Answer(s): A

Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

Answer(s): B

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0002025.html

Which statement regarding event monitors is TRUE?

Event monitor data can be reviewed while the event monitor is active
Event monitors must always be started manually after activating a database
Event monitors must write data to .EVT files before the data can be loaded into database tables
Event monitors are used to obtain information about how a database system looks at a specific point in time

Answer(s): B

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000915.html

Free C2090-600 Exam Braindumps (page: 5)