IBM C2090-600 Exam Practice Test Instant Access

Question 1

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

ALBAC protection can be applied to a nickname

BLBAC cannot be used to restrict access to a staging table

CLBAC cannot be used to restrict access to data of columns and rows in the same table

DLBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

Answer : D

Question 2

Which statement regarding event monitors is TRUE?

AEvent monitor data can be reviewed while the event monitor is active

BEvent monitors must always be started manually after activating a database

CEvent monitors must write data to .EVT files before the data can be loaded into database tables

DEvent monitors are used to obtain information about how a database system looks at a specific point in time

Answer : B

Question 3

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

Adb2val

Bdb2set

Cdb2look

Ddb2greg

Answer : B

Question 4

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?

AUPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

BUPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

CCONNECT TO sample;UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;

DATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

Answer : C

Question 5

Which statement about NOT ENFORCED unique constraints is TRUE?

ANOT ENFORCED unique constraints can not be defined on primary key columns

BThe query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan

CWhen attempting to insert data that does not conform to a NOT ENFORCED unique constraint, awarning will be returned

DStorage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

Answer : A

Question 6

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

ACatalog a storage access alias in the DB2 database

BCreate an FTP account on IBM Softlayer Object Storage

CUse the DB2REMOTE parameter of the LOAD command

DEstablish a remote connection to IBM Softlayer Object Storage using DB2 Connect

ECreate a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Answer : A, C

Question 7

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

Adb2cluster --cfs --list --filesystem datafs

Bdb2cluster --cfs --display --filesystem datafs

Cdb2cluster --cfs --listconfig --filesystem datafs

Ddb2cluster --cfs --displayconfig --filesystem datafs

Answer : A

IBM C2090-600 IBM DB2 11.1 DBA for LUW Exam Practice Test