IBM IBM Information Management P2090-047 New Questions

IBM PureData System for Transactions Technical Mastery Test v1 Questions and Answers

Question 17

A table, TableA has one column, ColumnA. The following query can be used to determine the skew of Table A.

Select distinct (ColumnA) from TableA;

Select distinct(datasliceid) from TableA;

Select datasliceid, count(*) from TableA group by 1 order by 2;

Select ColumnA, count(*) from TableA group by ColumnA order by 2;

Question 18

Which two commands can be used to shut the database system down? (Choose two.)

nzstop

nzdown

nzhw stop

nzsystem stop

service halt nps

Question 19

The primary copy of a dataslice is spread across how many disks?

12.