C2090-541 Exam Training Practice Tests (IBM DB2 9.7 DBA for Linux UNIX and Windows)]

Question 1

You want to estimate the potential index compression savings for existing indexes on a table What do you use to obtain this information?

A. RUNSTATS B. ADMIN_ESTIMATE_COMPRESS_INFO table function C. INSPECT D. ADMIN_GET_INDEX_COMPRESS_INFO table function

Correct Answer: D

Question 2

Which method may be used to collect deadlock information in DB2 9.7?

A. DB2_CAPTURE_LOCKTIMEOUT registry variable B. DB2DETAILDEADLOCK event monitor C. LOCKING event monitor D. DEADLOCKS event monitor

Correct Answer: C

Question 3

Given the DDL shown below:
CREATE TABLE tab1 (coll SMALLINT );
CREATE VIEW v1 AS SELECT coll FROMtabl WHERE coll > 25 ;
CREATE VIEW V2 AS SELECT COI1 FROM v1 WITH CASCADED CHECK
OPTION
CREATE VIEW v3 AS SELECT coll FROM v2 WHERE coll < 100 ;
Which statement will fail?

A. INSERT INTO v1 VALUES (5) B. INSERT INTO v3 VALUES (200) C. INSERT INTO v2 VALUES (35) D. INSERT INTO v3 VALUES (25)

Correct Answer: D

Question 4

Which group of memory consumers can be adjusted by the Self-Tuning Memory Manager (STMM)?

A. bufferpools, lock memory, sort memory, package cache B. buffer pools, database heap, utility heap, lock memory C. buffer pools, database heap, utility heap, package cache D. buffer pools, utility heap, sort memory, package cache

Correct Answer: A

Question 5

You have a UTIL_IMPACT_LIM of 50 and a UTIL_IMPACT_PRIORITY of 60 for the backup utility. What are the maximum amount of system resources that the backup utility can use?

A. 60% B. 50% C. 40% D. 30%

Correct Answer: D

Question 6

What are two valid protocols that can be used with the CATALOG NODE command to establish communication with a server named SERVER1? (Choose two.)

A. IPv6 B. named pipe C. token ring D. NetBIOS

Correct Answer: A,B

Question 7

The SELF_TUNING_MEM database configuration (db cfg) parameter is set to ON.
Which three statements will cause the memory tuner to actively tune memory within the database? (Choose three.)

A. One dbcfg parameter is set to AUTOMATIC or the size of at least one buffer pool is set to AUTOMATIC, and the DAT ABAS E_M E M O R Y db cfg parameter is set to a numeric value or to AUTOMATIC. B. Any two of LOCKLIST, SHEAPTHRES_SHR,PCKCACHESZ are set to AUTOMATIC. C. At least one buffer pool has its size set to AUTOMATIC. D. MAXLOCKS is set to AUTOMATIC. E. The SORTHEAP db cfg parameter is set to AUTOMATI

Correct Answer: A,B,E

Question 8

Index TAB 1X1 was created as shown below:
CREATE INDEX tablxl ON tab1(col_1)
Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement?

A. ALTER INDEXtablxl COMPRESS YES B. ALTER INDEXtablxl CLUSTER C. ALTER INDEXtablxl ADD COLUMN (col_2) D. ALTER INDEXtablxl PCTFREE 40

Correct Answer: A

Question 9

Click the Exhibit button.

What does the SQL in the exhibit show?

A. The SQL shows the most frequently used indexes on the SYSIBM.SYSINDEXES table since the last database activation B. THE SQL shows indexes on SYSIBM.SYSINDEXES table that have not been used since the last database activation. C. The SQL shows indexes on the SYSIBM.SYSTABLES table that are used for index-only access. D. The SQL shows the most frequently used indexes on the SYSIBM.SYSTABLES table since the last database activation.

Correct Answer: D

Question 10

Which two data types can be in-lined to enhance compression? (Choose two.)

A. GRAPHIC B. XML C. LOB D. LONG VARCHAR

Correct Answer: B,C

IBM DB2 9.7 DBA for Linux UNIX and Windows - C2090-541 Exam Practice Test