最新的DB2認證 C2090-546考試題庫

問題1

Which is true regarding collecting distribution statistics for XML data?

A. XML distribution statistics are collected for partitioned indexes over XML data defined on a data partitioned table.

B. XML distribution statistics are collected for indexes over XML data of type VARCHAR HASHED.

C. XML distribution statistics are collected for indexes over XML data of type VARCHAR.

D. XML distribution statistics are collected when collecting index statistics during index creation.

正確答案: C

問題2

Which category is used to audit the running of SQL statements?

A. OBJMAINT

B. CONTEXT

C. SQLMAINT

D. EXECUTE

正確答案: D

問題3

A database administrator wants to load XML data into the table DB2USER.T1 from the delimited ASCII file /home/user/xml/data1.del. Which command will load the XML data and validate it against a XML schema?

A. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLSCHEMA USING XDS INSERT INTO db2user.t1

B. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLVALIDATE USING XDS INSERT INTO db2user.t1

C. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLVALIDATE USING XMLSCHEMA INSERT INTO db2user.t1

D. LOAD FROM data1.del OF DEL XML FROM /home/user/xml INSERT INTO db2user.t1

正確答案: B

問題4

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. ALTER TABLE tab_a ADD PRIMARY KEY (c1)

B. CREATE INDEX taba_idx ON tab_a (c4)

C. CREATE INDEX taba_idx ON tab_a (c2)

D. CREATE UNIQUE INDEX taba_idx ON tab_a (c2)

正確答案: C

問題5

You have installed a copy of DB2 on your windows server. After the installation you only want to verify the instance (INSTANCE_NAME) of this installed copy followed by the starting of this database instance. Which of the following statements is correct?

A. db2val -i INSTANCE_NAME -s

B. db2val -i INSTANCE_NAME -a

C. db2val -i INSTANCE_NAME -v

D. db2val -i INSTANCE_NAME -o

正確答案: A

問題6

After executing the following statement: ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK What is the expected result?

A. The high water mark is lowered without moving any extents of TBSP1.

B. The extents of TBSP1 are moved around to lower the high water mark.

C. The high water mark for TBSP1 is lowered and the unused space is automatically reclaimed by the system.

D. The high water mark for TBSP1 is lowered and the unused space is automatically reclaimed by the system if TBSP1 is an automatic storage table space.

正確答案: B

問題7

Which two of the following can now be monitored with DB2 v9.7? (Choose two.)

A. Deadlocks, lock timeouts, and lock waits.

B. Memory consumption by static SQL statements.

C. Unit of work total memory usage.

D. Memory consumption by static and dynamic SQL statements.

E. Unit of work total CPU usage.

正確答案: A,E

問題8

If DB2 load operation is performed against a table which contains at least one XML column, which statement is true?

A. One compression dictionary is built for both relational data and for XML data.

B. One compression dictionary is built for relational data and one compression dictionary is built for the XML data.

C. One compression dictionary is built for relational data, XML data is not compressed.

D. One compression dictionary is built for relational data, one compression dictionary is built for XML data, and one compression dictionary is built for both relational and XML data.

正確答案: B

最新的IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade - C2090-546免費考試真題

最新更新

站內鏈接

聯系我們