IBM C1000-085 IBM Netezza Performance Server V11.x Administrator Exam Practice Test

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.

Create a copy of FACT_SALES table with zip_code as integer data type.

alter table fact_sales to organize on zip_code. followed by groom.

CREATE ORGANIZED view for FACT_SALES table

Create a view with a typecast to integer and use view for query purposes

Cloud Pak for Data

InfoSphere Data Replication

Netezza Replication Services

Data Serialization

NPS Backup and Restore

clientmgr.log

pg.log

sysmgr.log

dbos.log

system.cfg

pg_hba.conf

postgresql.conf

startup.cfg

DEFAULT

INITIALLY IMMEDIATE

INITIALLY DEFERRED

NULL

DEFERRABLE

not Nullable constraint

columns used for filters

distinct values

columns used for joins

table constraints

nzsqa progress

nzsqa wlm

nzsqa responders

nzsqa schedqueues -sys

48 bytes for ROWID, CREATEXID and DELETEXID only

32 bytes for ROWID. CREATEXID, DELETEXID and the null vector

32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns

24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns