IBM IBM Certifications P2090-047 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:

  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 63:

  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 64:

  Zone Maps provide what information about a table?

  A. The list of unique column values 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 65:

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

  B. 12

  C. 31

  D. > 96

  Correct Answer: D

• Question 66:

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

  A. One-up numbers are generated.

  B. Integers (whole numbers) 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 67:

  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 the FPGAs.

  Correct Answer: B

• Question 68:

  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 69:

  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.

  Correct Answer: D

• Question 70:

  To create a database table, at a minimum, what must be specified?

  A. column name and data type.

  B. column name, data type and primary key.

  C. column name, data type and default constraint.

  D. column name, data type and distribute on clause.

  Correct Answer: A