Free C1000-085 – IBM Netezza Performance Server V11.x Administrator Practice Test Question

Select all that apply, then click Submit answer.

• ○

  nzsql

• ○

  nz_ddl

• ○

  nzsqa

• ○

  nz_stats

• ○

  nzbackup

• ○

  nz tables
  
  
  
  
  
  
  

Select all that apply, then click Submit answer.

• ○

  DEFAULT

• ○

  INITIALLY IMMEDIATE

• ○

  INITIALLY DEFERRED

• ○

  NULL

• ○

  DEFERRABLE
  
  
  
  
  
  
  

Select all that apply, then click Submit answer.

• ○

  libnetinza-version.tar gz

• ○

  libnetsqlext-version.tar.gz

• ○

  libnetxml-version.tar.gz

• ○

  libnetcrypto-version.tar.gz

• ○

  libnetsqlkit-version.tar.gz
  
  
  
  
  
  
  

Select all that apply, then click Submit answer.

• ○

  DELETE

• ○

  ALTER VIEW

• ○

  ALTER TABLE

• ○

  CREAE TABLE

• ○

  REVOKE
  
  
  
  
  
  
  

Select all that apply, then click Submit answer.

• ○

  nz_plan querytext

• ○

  EXPLAIN PLAN FILE querytext

• ○

  EXPLAIN PLANGRAPH querytext

• ○

  EXPLAIN querytext

• ○

  nzsql -t querytext -0 planfile.pln
  
  
  
  
  
  
  

Select an option, then click Submit answer.

• ○

  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 reorder data.

• ○

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

Select an option, then click Submit answer.

• ○

  New event rules can be added using the queries panel in NPS Console.

• ○

  New event rules can be added using the event rules panel in NPS Console.

• ○

  New event rules can only be added in the host container.

• ○

  New event rules must be added using the npsaddevent command.
  
  
  
  
  
  
  

Select an option, then click Submit answer.

• ○

  create IBM Object Storage

• ○

  query performance

• ○

  create new service

• ○

  monitor snippets
  
  
  
  
  
  
  

Select an option, then click Submit answer.

• ○

  integers

• ○

  internal datatypes (ROWID etc.)

• ○

  temporal types

• ○

  strings
  
  
  
  
  
  
  

Select an option, then click Submit answer.

• ○

  nzsqa progress

• ○

  nzsqa wlm

• ○

  nzsqa responders

• ○

  nzsqa schedqueues -sys