IBM C1000-085 Exam Questions Instant Access

Question 1

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

A48 bytes for ROWID, CREATEXID and DELETEXID only

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

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

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

Answer : A

Question 2

Which two commands can be used to get a plan file for a query?

Anzsql -c 'show planfile '

Bnzsql -c 'select plan_text from _v_plan'

Cnzsql -c 'get planfile '

Dnz_get

Enz_plan

Answer : A, D

Question 3

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

AIBM Public GitHub Repository

BRed Hat Marketplace

Cdownload.google.com

DDocker Hub

Answer : D

Question 4

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

Anzcm ---inza

Bnzrev --inza

Cnzinza

Dinzarev

Answer : A

Question 5

When restoring a database using nzrestore utility, which is true for the npshost option?

AIt is the hostname of the storage server

BIt is a HOSTNAME value set in backupHostname.txt file on the backup source system.

CIt is a host name of the target system to restore a database to.

DIt is a remote host name or IP address of the system to connect to.

Answer : C

Question 6

Which statement is accurate regarding snippets?

AThe number of snippets depends on query and complexity.

BEvery query is always turned into four snippets.

CEvery query is always turned into one snippet.

DThe number of snippets is always based on the size of the system.

Answer : C

Question 7

How can a user update statistics on a table?

Aby running UPDATE STATISTICS

Bby running a query against the table

Cby running GENERATE STATISTICS

Dby restarting the database

Answer : A

IBM Netezza Performance Server V11.x Administrator C1000-085 Exam Questions