IBM C2090-544 Actual Free Exam Questions & Community Discussion
If table space TBSP1 is using automatic storage, and the existing storage paths are full, which command would increase the available storage?
Correct Answer: D
Vote an answer
Given the following statement: Which statement will successfully add a new partition to table T1 for April 2010?
Correct Answer: A
Vote an answer
A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?
Correct Answer: A
Vote an answer
Which type of table queue is used to pass data between database partitions when rows are being fetched?
Correct Answer: D
Vote an answer
Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?
Correct Answer: A
Vote an answer
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?
Correct Answer: C
Vote an answer
In which two environments would intra-partition parallelism be used? (Choose two.)
Correct Answer: A,B
Vote an answer
Which command will prevent prefetching during crash recovery?
Correct Answer: C
Vote an answer
An active partitioned instance named DB2INST1 uses the following db2nodes.cfg file:
1 server1 0
2 server1 1
3 server1 2
4 server1 3
The following command is issued to add a new database partition:
db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4
Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?
1 server1 0
2 server1 1
3 server1 2
4 server1 3
The following command is issued to add a new database partition:
db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4
Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?
Correct Answer: C
Vote an answer
0
0
0
10