最新的IBM Certified Database Administrator認證 C2090-600考試題庫

問題1

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

A. The AUTO_REORG database configuration parameter is set to NO.

B. The INTRA_PARALLEL database manager configuration parameter is set to NO.

C. The PAGESIZE database configuration parameter is set to 32K.

D. The DFT_EXTENT_SZ database configuration parameter is set to 8.

E. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.

正確答案: B,E

問題2

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

A. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

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 can be applied to a nickname

正確答案: A

問題3

How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

A. Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the
ALTER BUFFERPOOL statement after making sure that at least one entry is present in
SYSCAT.BUFFERPOOLDBPARTITIONS.

B. Set the SELF TUNING_MEM database configuration parameter to ON using the UPDATE
DATABASECONFIGURATION command or the db2CfgSet API.

C. Set the sort heap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE
DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.

D. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.

正確答案: B

問題4

Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)

A. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)

B. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1

C. ALTER TABLE tab1 APPEND ON

D. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL

E. ALTER TABLE tab1 DROP COLUMN col1

正確答案: D,E

問題5

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

A. ATTACH TO db2instl;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

B. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

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

D. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

正確答案: C

問題6

Which statement regarding event monitors is TRUE?

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

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

C. Event monitors must always be started manually after activating a database

D. Event monitor data can be reviewed while the event monitor is active

正確答案: C

最新的IBM DB2 11.1 DBA for LUW - C2090-600免費考試真題

最新更新

站內鏈接

聯系我們