C1000-085 Online Practice Questions and Answers

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

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

B. After the row is inserted into the table.

C. Before the row is inserted into the table.

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

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

A. online

B. running

C. stopped

D. paused

Which command is used to register a user defined table function in the database?

A. CREATE FUNCTION

B. nzudxcompile

C. ALTER FUNCTION

D. ECHO

IBM Netezza Performance Server drivers for the Go Language can be obtained from which location?

A. IBM Public GitHub Repository

B. Red Hat Marketplace

C. download.google.com

D. Docker Hub

Which two cross-database SQL operations are allowed?

A. DELETE

B. ALTER VIEW

C. ALTER TABLE

D. CREAE TABLE

E. REVOKE

What command is used to verify the release of IBM Netezza Performance Server Analytics installed?

A. nzcm --inza

B. nzrev --inza

C. nzinza

D. inzarev

Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

A. It reclaims space from deleted rows and does not re-order data

B. Enough space is required for GROOM to make a complete copy of the table

C. GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re- order data.

D. It reclaims space from deleted rows and re-orders data.

Which is a valid statement regarding event rules on the IBM Netezza Performance Server (NPS) Console?

A. New event rules can be added using the queries panel in NPS Console.

B. New event rules can be added using the event rules panel in NPS Console.

C. New event rules can only be added in the host container.

D. New event rules must be added using the npsaddevent command.

The nzhostbackup command backs up which directory by default?

A. /nz/data/

B. /nzscratch/

C. /ex port/ho me/nz

D. /nz/kit/

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.