IBM C2090-600 Exam Practice Test Instant Access

Question 1

Which DB2 Explain Facility tool uses the Explain tables to display access plain information?

Adb2look

Bdb2advis

Cdb2expln

Ddb2exfmt

Answer : C

Question 2

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

ASet the DB2COMM registry variable to DB2COMM=SSL

BSet the DB2COMM registry variable to DB2COMM=SSL, TCPIP

CSet the AUTHENTICATION configuration parameter to DATA_ENCRYPT

DSet the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

Answer : B

Question 3

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 4

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 5

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 6

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 7

A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?

AAll data, both new and existing, will becompressed.

BOnly new or updated data for XML columns will be compressed.

CNew and existing XML columns will be compressed but other columns remain unchanged.

DExisting data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.

Answer : D

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