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
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.
What are two primary purposes of UDX?
it is a required component of all Netezza SQL commands
to force execution only on the SPU nodes
to offer new and unique types of analyses through customized code
to showcase one's capability to write UDX code to duplicate existing SQL functions
to accelerate analysis by processing data in-database
What is required in order to restore a specific table using the nz_restore support tool?
A table needs to be backed up by using nzbackup utility.
A table that is being restored must have the same name in the backup set.
The userspace must be provided
The table structure (DDL) needs to exist
TESTED 23 Mar 2023
Copyright © 2014-2023 DumpsTool. All Rights Reserved
