最新的IBM P2090-047免費考試真題

問題1

Which nzload operation statement is correct?

A. nzload must be run from the PureData System for Analytics host.

B. nzload must have a control file.

C. nzload performs singleton inserts.

D. nzload user must have CREATE EXTERNAL TABLE privilege.

正確答案: D

問題2

When a poor choice of distribution key is made, what is the impact to storage allocation?

A. Data is likely to be unevenly spread across the system.

B. Data is likely to negatively affect views.

C. Data is likely to negatively affect compression.

D. Data is likely to generate duplicate sequence values.

正確答案: A

問題3

What is the fastest join utilized by PureData System for Analytics?

A. Hash join.

B. Cross product join.

C. Expression join.

D. Merge join.

正確答案: A

問題4

When creating a table, you can specify a column constraint for each individual column of either "NULL" or "NOT NULL". When column values are later evaluated within a query statement, which of these is true?

A. 0 is equal to null, the empty string ( '' ) is equal to null.

B. 0 is equal to null, the empty string ( '' ) is not equal to null.

C. 0 is not equal to null, the empty string ( '' ) is equal to null.

D. 0 is not equal to null, the empty string ( '' ) is not equal to null.

正確答案: D

問題5

Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from the system?

A. nzsystem

B. nzhw

C. nzinventory

D. sar

正確答案: B

問題6

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

A. OLE-DB is not supported on UNIX.

B. Install the JDBC driver for UNIX.

C. Install the ODBC driver for UNIX.

D. Install the OLE-DB driver for UNIX.

正確答案: A

最新的IBM PureData System for Transactions Technical Mastery Test v1 - P2090-047免費考試真題

聯系我們

站內鏈接

最新更新