← Back to exam page

C1000-085 – IBM Netezza Performance Server V11.x Administrator

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which two cross-database SQL operations are allowed?

Select all that apply, then click Submit answer.

  • ○

    DELETE

  • ○

    ALTER VIEW

  • ○

    ALTER TABLE

  • ○

    CREAE TABLE

  • ○

    REVOKE






Question 5

Which two commands will show a query plan without running the query?

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






Question 6

Which statement is true when executing the GROM command on a Clustered Base Table

(CBT)?

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.