IBM IBM Certifications P2090-050 Questions & Answers

• Question 61:

  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;

  Correct Answer: D

• Question 62:

  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.

  Correct Answer: C

• Question 63:

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

  B. 12

  C. 31

  D. > 96

  Correct Answer: D

• Question 64:

  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.

  Correct Answer: B

• Question 65:

  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.

  Correct Answer: A

• Question 66:

  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.

  Correct Answer: B

• Question 67:

  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

  Correct Answer: A

• Question 68:

  Which attribute CANNOT be defined for both users and groups?

  A. Row set limit.

  B. Default priority.

  C. Query time out.

  D. Password expiration.

  Correct Answer: D

• Question 69:

  Which two characteristics describe materialized views. (Choose two.)

  A. Materialized views can contain aggregates.

  B. Materialized views can contain a HAVING clause.

  C. Materialized views can contain a WHERE clause.

  D. Materialized views can contain an ORDER BY clause.

  E. Materialized views can reference only onebase table in the FROM clause.

  Correct Answer: DE

• Question 70:

  What is a benefit of Clustered Base Tables?

  A. Replicates base table data.

  B. An alternate way to order a table's data.

  C. Materializes on disk joins between tables.

  D. Increases the performance of load operations.

  Correct Answer: B