C1000-085 Online Practice Questions and Answers
What access is required to create a new user in IBM Netezza Performance Server?
A. An account with NEW USER administrative privilege
B. An account with CREATE USER administrative privilege.
C. An account with CREATE GROUP access on the host OS.
D. An account with CREATE ID access on the host OS.
To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated?
A. system.cfg
B. pg_hba.conf
C. postgresql.conf
D. startup.cfg
What is the maximum length of a CHAR/VARCHAR column?
A. 65.535
B. 32.000
C. 64,000
D. 16.000
Which system view stores the information on how many resources have been allocated for the resource group versus how many were allowed?
A. _v_sched_gra
B. _v_system_util
C. _v_qryhist
D. _v_plan_resource
What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?
A. nzsqa progress
B. nzsqa wlm
C. nzsqa responders
D. nzsqa schedqueues -sys
Within a database session, which syntax allows a user to change to a different schema (NEW_SCHEMA)?
A. ALTER SESSION SET SCHEMA=NEW_SCHEMA
B. SET CURRENT SCHEMA TO NEW_SCHEMA
C. SET SCHEMA NEW_SCHEMA
D. ALTER DATABASE database name SET DEFAULT SCHEMA NEW SCHEMA
What command is used to add an event?
A. nzevent add
B. nzevent insert
C. nzevent load
D. nzevent create
To how many resource groups can a user be assigned?
A. four
B. unlimited
C. three
D. one
What two files are extracted from the SQL Extension toolkit package?
A. libnetinza-version.tar gz
B. libnetsqlext-version.tar.gz
C. libnetxml-version.tar.gz
D. libnetcrypto-version.tar.gz
E. libnetsqlkit-version.tar.gz
Which statement regarding the IBM Netezza Performance Server (NPS) admin database user is true?
A. The admin user should be deleted after installing NPS.
B. The admin user is added to the host OS before installing NPS.
C. The admin user can not be deleted after installing NPS.
D. The admin user is the only owner of a database on NPS.