IBM DB2 9.7 Advanced DBA for LUW - C2090-544 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which statement is true about clustering indexes in a partitioned database?

A. The clustering index column(s) should be prefixed by the partitioning key column(s). B. The partitioning key column(s) should be added to the clustering index with the INCLUDE option. C. The clustering index column(s) should be suffixed by the partitioning key column(s). D. The partitioning key column(s) should be added immediately after the column in the clustering index with the highest cardinality.

Discussion 0

Correct Answer: A Vote an answer

Question 2

Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?

A. SORTHEAP AUTOMATIC, SHEAPTHRES 0 B. SORTHEAPTHRES 10000K, SORTHEAP 250K C. SORTHEAP AUTOMATIC, SHEAPTHRES 10000K D. SORTHEAPTHRES 10000K

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which command CANNOT be used to create the compression dictionary for a table?

A. LOAD B. RUNSTATS C. IMPORT D. INSPECT

Discussion 0

Correct Answer: B Vote an answer

Question 4

The table STORESALES was created with the following statement:

Which is true when the following statement is executed?
CREATE UNIQUE INDEX index_partIDcustID ON storesales (partID, custID)

A. A unique non-partitioned index is created successfully. B. A non-unique partitioned index is created successfully. C. A unique partitioned index is created successfully. D. The index creation fails because it does not contain the column from the table partitioning key.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful? (Choose two.)

A. INTRA_PARALLEL YES B. MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100 C. INTRA_PARALLEL NO D. MAX_AGENTS 100, MAX_CONNECTIONS 2000 E. MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000

Discussion 0

Correct Answer: A,B Vote an answer

Question 6

Which action(s) will cause a compression dictionary to be removed from a table?

A. Set the table COMPRESS attribute to NO; run INSPECTESETDICTIONARY against the table. B. Set the table COMPRESS attribute to NO; run REORG against the table. C. Set the table COMPRESS attribute to NO; run RUNSTATS against the table. D. Set the table COMPRESS attribute to NO.

Discussion 0

Correct Answer: B Vote an answer

Question 7

Which of the following techniques will ensure that you CANNOT encounter two active primary servers in an HADR pair?

A. Catalog both servers separately and use a fixed IP address for both servers. B. Use a virtual IP Address for both servers. C. Use a virtual IP Address in the CATALOG DATABASE command. D. Set ALTERNATER SERVER to fixed IP Addresses on both servers.

Discussion 0

Correct Answer: C Vote an answer

Question 8

What is the minimum authority required to execute the RUNSTATS command against a table?

A. DATAACCESS B. SECADM C. SYSMON D. SQLADM

Discussion 0

Correct Answer: D Vote an answer

Question 9

If the shared sort heap threshold parameter SHEAPTHRES_SHR is set to AUTOMATIC, what will happen?

A. All sorts will be done in a temporary table space. B. The shared sort memory allocation will be controlled by DB2. C. All sorts will be done in shared memory. D. No shared memory is allocated for sorting.

Discussion 0

Correct Answer: B Vote an answer

Question 10

What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

A. SECADM authority B. EXECUTE privilege on audit routines with DATA C. EXECUTE privilege on audit routines with NO DATA D. SYSADM authority E. DBADM authority

Discussion 0

Correct Answer: A,B Vote an answer