C1000-085 Sample Questions Answers

nzsql

nz_ddl

nzsqa

nz_stats

nzbackup

nz tables

Queries and transactions are not interrupted by drive failure if their data is not on the failed drive.

Queries and transactions are not interrupted in the event of a drive failure.

Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives.

Running queries and transactions will finish, but new transactions will not be allowed till drive is changed.

To define load operations in a text file instead of having to specify options on the command line

To ensure that a simple load that uses external tables continues after the system is paused and resumed.

To take advantage of a named pipe capability to stream the data to external tables faster.

To control the re-load operations of me data file after every load failure

any column used in table constraints

any column with low cardinality

a technical or surrogate key

any date column commonly used in queries

DELETE

ALTER VIEW

ALTER TABLE

CREAE TABLE

REVOKE

NFS is handled by Red Hat OpenShift and does not need to be mounted.

Sysmgr will remount it as part of the IBM Netezza Performance Server environment

A containers do not allow for NFS mounts.

It will be automatically mounted by the ipsnfs service.

system.cfg

pg_hba.conf

postgresql.conf

startup.cfg

not Nullable constraint

columns used for filters

distinct values

columns used for joins

table constraints

ap node power off

ap node set__personality fail

ap stopnode

ap node disable

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

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

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

New event rules must be added using the npsaddevent command.

ap hw

nzsw

nzhv

ap sw

oc pod -h -s

48 bytes for ROWID, CREATEXID and DELETEXID only

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

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

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

nzsql -c "show planfile "

nzsql -c "select plan_text from _v_plan"

nzsql -c "get planfile "

nz_get

nz_plan

by running UPDATE STATISTICS

by running a query against the table

by running GENERATE STATISTICS

by restarting the database

text-delimited

fixed-length

JSON

HL7

XML