C2090-600問題集、IBM実際の試験問題

質問 1

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

A. REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND IN DEXES ALL;

B. RUNSTATS ON TABLE sales IN PLACE AND INDEXES ALL;

C. REORG TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;

D. RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;

正解: C

質問 2

When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density.
What can cause an MDC table to use much more space?

A. The extent size is too small.

B. High cardinality of the dimension(s) chosen.

C. The page size is too small.

D. Low cardinality of the dimension(s) chosen.

正解: B

質問 3

Which of the following statements about compression for BLU MPP tables is TRUE?

A. Unique compression dictionaries are generated for each partition

B. Compression must be explicitly enabled for BLU MPP tables

C. Each table has a single compression dictionary that getsreplicated across all partitions

D. Compression requires decompression to evaluate partition joins

正解: C

質問 4

Which of the following are all valid types of trigger?

A. ATOMIC, BEFORE, INSTEAD OF

B. AFTER, ATOMIC, INSTEAD OF

C. AFTER, ATOMIC, BEFORE

D. AFTER, BEFORE, INSTEAD OF

正解: D

質問 5

When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)

A. The routine must return either an integer or a null.

B. The routine must be cross-compatible with Oracle PL/SQL syntax rules.

C. The routine must be generated with IBM Database Conversion Workbench (DCW).

D. The routine cannot contain argument lists or variable arguments (varargs).

E. The routine cannot contain comments.

正解: A,D

質問 6

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

A. 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.

B. 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.

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

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

正解: D

IBM DB2 11.1 DBA for LUW - C2090-600 模擬練習