IBM
P2090-050 · Question #78
A table, TableA has one column, ColumnA. The following query can be used to determine the skew of Table A.
The correct answer is C. Select datasliceid, count(*) from TableA group by 1 order by 2. See the full explanation below for the reasoning.
Question
A table, TableA has one column, ColumnA. The following query can be used to determine the skew of Table A.
Options
- ASelect distinct (ColumnA) from TableA;
- BSelect distinct(datasliceid) from TableA;
- CSelect datasliceid, count(*) from TableA group by 1 order by 2;
- DSelect ColumnA, count(*) from TableA group by ColumnA order by 2;
How the community answered
(54 responses)- A4% (2)
- B7% (4)
- C72% (39)
- D17% (9)
Community Discussion
No community discussion yet for this question.