Pass Using P2090-047 Exam Dumps

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

Question 9

Which statement is true regarding the compress engine?

Data automatically gets compressed.

Columns to be compressed must be defined.

The nzcompress utility must be run to compress the table.

The nzcompress utility must be run to compress the database.

Question 10

Which of the following is a valid datatype definition?

TEXT

CLOB

CHAR(64000)

NUMERIC(1,38)

Question 11

OLE-DB based applications requires which PureData System for Analytics software?

Install the JDBC driver for windows.

Install the ODBC driver for windows.

Install the OLE-DB Driver for windows.

Install the nzload bulk load for windows.

Question 12

Which statement is true regarding any database user?

The user has a table space defined.

The user can be assigned to more than one group.

The user must have a corresponding host account.

The user can be removed from the default PUBLIC group.