P2090-047 IBM PureData System for Transactions Technical Mastery Test v1 Questions and Answers

GROOM TABLE requires space to make a complete copy of the table.

GROOM TABLE only operates on tables that include an ORGANIZE ON clause.

GROOM TABLE prevents nzload from adding data while groom is in progress.

GROOM TABLE allows UPDATE, DELETE, and INSERT operations to occur while groom is in progress.

It accepts zero or more input values but produces one output value.

It accepts exactly one input value and produces exactly one output value.

it accepts exactly one input value and produces one or more output values.

It accepts zero or more input values and produces one or more output values.

All user space is available for database expansion.

Each database is assigned it's own section of disk space.

When creating the database you can specify which disks to use.

When you create a database you can set the maximum space it is allowed to use.

All users must belong to admin group.

Creation of users and groups is not allowed.

Users and groups are local and tied to a particular database.

Users and groups are global and not tied to a particular database.

One fan fails.

One disk fails.

Active host fails.

One power supply fails.

Use a CURSOR.

Use an EXTERNAL table.

Use the COPY command.

Increase the PreFetch Count.

Table will not join.

Table will not broadcast.

Table is likely to be skewed.

Table is likely to be evenly spread across data slices.

/var/log

/usr/local

/nz/kit/log

The SYSTEM database

Both tables have primary keys defined.

Both join columns have the same name.

Both tables must be distributed on random.

Both join columns have identical data types.

Both tables must be distributed on their join column.

nzload runs on windows.

nzload runs on SuSE Linux.

nzload blocks update/delete against the target table.

nzload runs on the PureData System for Analytics host.

A DELETE from TableA

A SELECT from TableA

A TRUNCATE of TableA

An nzbackup of the database in which TableA resides

Scrollable Cursors

Looping (while, for)

Conditionals (if/else)

Returning a scalar result or a result set

Fan

Disk

Host

S-Blade

Serializable

Committed read

Repeatable read

Uncommitted read

Use explain.

Use statistics.

Use pg.log file.

Set show_plan = true;

BIGINT

FLOAT8

NUMERIC(38,0)

VARCHAR(256)