P2090-047問題集、IBM実際の試験問題

質問 1

Which procedural logic is NOT supported by NZPLSQL?

A. Scrollable Cursors

B. Looping (while, for)

C. Returning a scalar result or a result set

D. Conditionals (if/else)

正解: A

解説: (PassTest メンバーにのみ表示されます)

質問 2

What function can nzbackup perform?

A. Back up the data using the specified number of streams.

B. Back up host data (catalog metadata).

C. Back up TEMP tables.

D. Back up pg.log files.

正解: A

質問 3

You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?

A. Select * from PROD..TableA

B. Truncate table PROD..TableA

C. Delete from PROD..TableA

D. Insert into PRO.TableA select * from DEV..TableB

正解: A

質問 4

Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)

A. The column histogram statistics.

B. The number of rows in the table.

C. The number of NULLs in each column.

D. The number of unique values in each column.

E. The minimum and maximum column value information (excluding text columns).

正解: B,E

質問 5

When is the ToplogyImbalance event triggered?

A. When a disk enclosure's voltage sensor is reading outside the nominal range.

B. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).

C. When the path the path between an S-Blade and its disks has failed.

D. When a SAS switch has failed.

正解: B

質問 6

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

A. Install the ODBC driver for windows.

B. Install the JDBC driver for windows.

C. Install the OLE-DB Driver for windows.

D. Install the nzload bulk load for windows.

正解: C

IBM PureData System for Transactions Technical Mastery Test v1 - P2090-047 模擬練習