Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

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.

Which two command line support tools are used to determine the order of data for a given table?

A.

nz_physical_table_layout

B.

nz_zonemap

C.

nz_pagemap

D.

nz_sort_order

E.

nz_get

Which is the most efficient data type for distribution keys?

A.

integers

B.

internal datatypes (ROWID etc.)

C.

temporal types

D.

strings

What command is used to add an event?

A.

nzevent add

B.

nzevent insert

C.

nzevent load

D.

nzevent create

What is the order of the operations of a typical snippet in a query plan?

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

What are Clustered Base Tables (CBT)?

A.

Tables that decrease allocated storage

B.

Tables that contain sorted data using one to four columns.

C.

Tables that increase pre-sorting of new table records before a loading operation.

D.

Tables that replicate the base table.

When computing the row size for a table row, what overhead should be accounted for?

A.

48 bytes for ROWID, CREATEXID and DELETEXID only

B.

32 bytes for ROWID. CREATEXID, DELETEXID and the null vector

C.

32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns

D.

24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns