IBM Exam Questions

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

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

A.
“CREATE TABLE TableA (LastName VARCHAR(20));

B.
“CREATE TABLE TableA (LastName VARCHAR(20));
ALTER TABLE TableA ZONEMAP ON (LastName);

C.
“CREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);

D.
“CREATE TABLE TableA (LastName VARCHAR(20));
CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY LastName;

Explanation: