最新的IBM Netezza Performance Server V11.x Administrator - C1000-085免費考試真題

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

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

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

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

A. 48 bytes for ROWID, CREATEXID and DELETEXID only

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

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

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

A. A table that is being restored must have the same name in the backup set.

B. A table needs to be backed up by using nzbackup utility.

C. The userspace must be provided

D. The table structure (DDL) needs to exist

A. The admin user is added to the host OS before installing NPS.

B. The admin user can not be deleted after installing NPS.

C. The admin user should be deleted after installing NPS.

D. The admin user is the only owner of a database on NPS.

A. by restarting the database

B. by running UPDATE STATISTICS

C. by running GENERATE STATISTICS

D. by running a query against the table

A. /nz/kit/

B. /nzscratch/

C. /nz/data/

D. /ex port/ho me/nz

A. _v_sched_gra

B. _v_system_util

C. _v_plan_resource

D. _v_qryhist