GET 70% Discount on All Products Coupon code: "Board70"
What is the order of the operations of a typical snippet in a query plan?
Which command is used to register a user defined table function in the database?
CREATE FUNCTION
nzudxcompile
ALTER FUNCTION
ECHO
What is a purpose of the command nzsystem?
to show and change the system state
to show and change nzroot use
to show and change system users
to show and change system access
https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.adm.doc/r_sysadm_nzsystem_cmd.html
Which is the most efficient data type for distribution keys?
integers
internal datatypes (ROWID etc.)
temporal types
strings
What two files are extracted from the SQL Extension toolkit package?
libnetinza-version.tar gz
libnetsqlext-version.tar.gz
libnetxml-version.tar.gz
libnetcrypto-version.tar.gz
libnetsqlkit-version.tar.gz
What are two valid column constraints?
DEFAULT
INITIALLY IMMEDIATE
INITIALLY DEFERRED
NULL
DEFERRABLE
Which two file formats are valid for external tables?
text-delimited
fixed-length
JSON
HL7
XML
What access is required to create a new user in IBM Netezza Performance Server?
An account with NEW USER administrative privilege
An account with CREATE USER administrative privilege.
An account with CREATE GROUP access on the host OS.
An account with CREATE ID access on the host OS.
Which two commands can be used to get a plan file for a query?
nzsql -c "show planfile "
nzsql -c "select plan_text from _v_plan"
nzsql -c "get planfile "
nz_get
nz_plan
TESTED 22 Feb 2025
