Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?
A. Use statistics.
B. Set show_plan = true;
C. Use pg.log file.
D. Use explain.
正解:D
質問 2:
Which statement is true regarding the compress engine?
A. Data automatically gets compressed.
B. The nzcompress utility must be run to compress thedatabase.
C. Columns to be compressed must be defined.
D. The nzcompress utility must be run to compress the table.
正解:A
質問 3:
Which will result in support for zonemaps on the LastName column?
A. CREATE TABLE TableA (LastName VARCHAR(20));
CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY
LastName;
B. CREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);
C. CREATE TABLE TableA (LastName VARCHAR(20));
D. CREATE TABLE TableA (LastName VARCHAR(20));
ALTER TABLE TableA ZONEMAP ON (LastName);
正解:A
質問 4:
Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?
A. Disk to FPGA to S-Blade to User.
B. Disk to FPGA to S-Blade to Host to User.
C. Disk to FPGA to Host to User.
D. Disk to Host to S-Bladeto FPGA to User.
正解:B
質問 5:
Which statement is true about a simple load using external tables?
A. The load can be configured to automatically create a backup file of the table being loaded.
B. The load can be configured to automatically continue toload if the S-Blade resets or fails.
C. The load can be configured to automatically remove duplicate rows from the table being loaded.
D. The load can be configured to automatically create a duplicate copy of the table being loaded.
正解:B
質問 6:
On which component(s) does the UDX run?
A. The host only.
B. The S-blades and the FPGAs only.
C. The host and the S-blades only.
D. The host, the S-blades and theFPGAs.
正解:C
質問 7:
Which piece ofinformation is NOT gathered as part of the statistical information when generate statistics is run on a table?
A. The number of updated rows in the table.
B. The number of rows in the table.
C. The number of unique or distinct values in each column.
D. The minimum and maximum value in each column.
正解:A
質問 8:
Which statement is true about optimizer settings?
A. They can be set at the session and at the group level.
B. They can be set system wide only.
C. They can be set system wide and at the session level.
D. They can be set at the database level only.
正解:C
質問 9:
What is the only predefined database user, which is able to access all objects and perform all tasks against the database?
A. root
B. admin
C. system
D. public
正解:B
清水** -
2週間前までIBM製品にさわったことすらなかった私ですが、評判の良かったこの問題集で勉強して合格する事ができました。
全く0からのスタートだったので、一通りテキストを学習したあと、すべて暗記するまでひたすら模擬試験に挑戦しました。
ともて役に立ちました。ありがとうございました。