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.