C1000-085 Exam Dumps : IBM Netezza Performance Server V11.x Administrator

It reclaims space from deleted rows and does not re-order data

Enough space is required for GROOM to make a complete copy of the table

GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.

It reclaims space from deleted rows and re-orders data.

not Nullable constraint

columns used for filters

distinct values

columns used for joins

table constraints

An account with NEW USER administrative privilege

An account with CREATE USER administrative privilege.

An account with CREATE GROUP access on the host OS.

An account with CREATE ID access on the host OS.