nerdexam
IBM

P2090-050 · Question #114

Which will result in support for zonemaps on the LastName column?

The correct answer is D. CREATE TABLE TableA (LastName VARCHAR(20)). See the full explanation below for the reasoning.

Question

Which will result in support for zonemaps on the LastName column?

Options

  • ACREATE TABLE TableA (LastName VARCHAR(20));
  • BCREATE TABLE TableA (LastName VARCHAR(20));
  • CCREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);
  • DCREATE TABLE TableA (LastName VARCHAR(20));

How the community answered

(45 responses)
  • A
    7% (3)
  • B
    2% (1)
  • C
    9% (4)
  • D
    82% (37)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full P2090-050 Practice