IBM PureData System for Analytics Technical Mastery Test v1 v5.0 (P2090-050)

Page:    1 / 9   
Total 140 questions

Which of the following is a valid datatype definition?

  • A. TEXT
  • B. CLOB
  • C. CHAR(64000)
  • D. NUMERIC(1,38)


Answer : C

Columns in a table may be zonemapped. How are those columns chosen?

  • A. They are automatically selected by the system.
  • B. They are based on the same columns as the table's distribution key.
  • C. They are added via the ALTER TABLE ADD INDEX(column_name) statement.
  • D. They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement.


Answer : A

When doing a CREATE SEQUENCE, the largest "maximum value" is based onwhat?

  • A. BIGINT
  • B. FLOAT8
  • C. NUMERIC(38,0)
  • D. VARCHAR(256)


Answer : A

On which component(s) does the UDX run?

  • A. The host only.
  • B. The host and the S-blades only.
  • C. The S-blades and the FPGAs only.
  • D. The host, the S-blades and theFPGAs.


Answer : B

Which procedural logic is NOT supported by NZPLSQL?

A. Scrollable Cursors -
B. Looping (while, for)
C. Conditionals (if/else)
D. Returning a scalar result or a result set



Answer : A Topic 2, Volume B

Which attribute CANNOT be defined for both users and groups?

  • A. Row set limit.
  • B. Default priority.
  • C. Query time out.
  • D. Password expiration.


Answer : D

Zone Maps provide what information about a table?

  • A. The list of unique columnvalues found within an extent.
  • B. An index pointer to each row's exact location in the base table.
  • C. The minimum and maximum column values found within an extent.
  • D. The connection between the map and reduce stages when using MapReduce.


Answer : C

What is the maximum number of databases that can be created?

  • A. 1
  • B. 12
  • C. 31
  • D. > 96


Answer : D

When working with sequences, which statement will always be true?

  • A. One-up numbers are generated.
  • B. Integers (wholenumbers) are generated.
  • C. The first value generated is the number 1.
  • D. The sequence number assigned will be unique across all tables and databases.


Answer : B

What is a characteristic of a column that is based on the TIMESTAMP datatype?

  • A. It includes a date portion.
  • B. It includes a timezone offset.
  • C. The value is reevaluated each time the row is selected.
  • D. The value is initially assigned when the row is first created.


Answer : A

Which will result in support for zonemaps on the LastName column?

  • A. CREATE TABLE TableA (LastName VARCHAR(20));
  • B. CREATE TABLE TableA (LastName VARCHAR(20)); ALTER TABLE TableA ZONEMAP ON (LastName);
  • C. CREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);
  • D. CREATE TABLE TableA (LastName VARCHAR(20)); CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY LastName;


Answer : D

What is the maximum number of columns you can choose as organizing keys for clustered base table?

  • A. 1
  • B. 2
  • C. 4
  • D. 8


Answer : C

Which clause CANNOT be used with a CREATE VIEW statement?

  • A. SUM ()
  • B. GROUP BY
  • C. ORDER BY
  • D. OUTER JOIN


Answer : C

When doing a CREATE TABLE, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)

  • A. NULL
  • B. UNIQUE
  • C. NOT NULL
  • D. PRIMARY KEY
  • E. DEFAULT value


Answer : B,D

Which statement is true regarding any database user?

  • A. The user has a table spacedefined.
  • B. The user can be assigned to more than one group.
  • C. The user must have a corresponding host account.
  • D. The user can be removed from the default PUBLIC group.


Answer : B

Page:    1 / 9   
Total 140 questions