C1000-085 Leak Questions

IBM Netezza Performance Server V11.x Administrator Questions and Answers

Question 5

Which three scripts are included in the IBM Netezza Performance Server Software Support Tools?

nzsql

nz_ddl

nzsqa

nz_stats

nzbackup

nz tables

Question 6

Which statement is correct about command nz_responders?

displays user activity in tabular format

displays information from nzsql responders -all in a more user-friendly format

displays information from nzsqa responders -sys in a more user-friendly format

displays resource utilization statistics in JSON format

Question 7

When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?

The PK constraint is never checked when a row is inserted into the table.

After the row is inserted into the table.

Before the row is inserted into the table.

The PK constraint is only checked during a GENERATE STATISTICS operation.

Question 8

Which system view stores the information on how many resources have been allocated for the resource group versus how many were allowed?

_v_sched_gra

_v_system_util

_v_qryhist

_v_plan_resource