C2090-546 試験問題を無料オンラインアクセス

If table TAB_A is created as follows:

Assuming the cardinality of the columns is the same, which statement will create an index that will benefit the most from compression?

• A.CREATE INDEX taba_idx ON tab_a (c2)
• B.CREATE INDEX taba_idx ON tab_a (c4)
• C.ALTER TABLE tab_a ADD PRIMARY KEY (c1)
• D.CREATE UNIQUE INDEX taba_idx ON tab_a (c2)

You are creating a table with 1 LOB column. The size of the LOB column is less than the size of the LOB descriptor. When creating this table you did not specify an INLINE LENGTH. Which option is correct?

• A.The ALTER TABLE .. INLINE LENGTH .. command is required so the LOB data can be included in the base table.
• B.Both the LOB descriptor and the LOB data will be stored in the base table.
• C.Only the LOB data will be stored in the base table.
• D.Only the LOB descriptor will be stored in base table and the LOB data will be stored in the LOB storage object.

If table TAB_A and index TABA_IDX are created as follows:

What can be compressed?

• A.All data in table TAB_A and index TABA_IDX.
• B.Only data in columns C1 and C2 in table TAB_A and index TABA_IDX.
• C.All data in table TAB_
• D.Only data in columns C1 and C2 of table TAB_A.

When the DIAGSIZE database manager configuration parameter is set to 10 on a Linux or Unix OS, what behavior will occur?

• A.DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files and limits the total size of the 20 files to 10 MB.
• B.DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files that are 10 MB in size.
• C.DB2 limits the size of the db2diag.log and <instance>.nfy files to 10 MB, and purges the old records when the limit is reached.
• D.DB2 rotates through 10 db2diag.log files that are 10 MB in size.

A database administrator wants to prune the Recovery History file for the SAMPLE database so that all objects older than February 1, 2008 (including those marked DB2HISTORY_STATUS_DO_NOT_DELETE) are removed from the file. Which commands will ensure all related recovery objects are automatically removed by DB2?

• A.UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ ON; PRUNE HISTORY 200801 WITH FORCE OPTION AND DELETE;
• B.UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ ON; PRUNE HISTORY 20080101 AND DELETE;
• C.UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ OFF; PRUNE HISTORY 200801 WITH FORCE OPTION;
• D.UPDATE DB CFG FOR sample USING AUTO_DEL_REC_OBJ OFF; PRUNE HISTORY 200801 WITH FORCE OPTION AND DELETE;