IBM IBM Certifications P2090-050 Questions & Answers

• Question 71:

  When are zonemaps initially created for a table?

  A. nzbackup

  B. nzreclaim

  C. CREATE TABLE

  D. ALTER TABLE ADD ZONEMAPS

  Correct Answer: C

• Question 72:

  Which of the following is a valid datatype definition?

  A. TEXT

  B. CLOB

  C. CHAR(64000)

  D. NUMERIC(1,38)

  Correct Answer: C

• Question 73:

  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.

  Correct Answer: A

• Question 74:

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

  A. BIGINT

  B. FLOAT8

  C. NUMERIC(38,0)

  D. VARCHAR(256)

  Correct Answer: A

• Question 75:

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

  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

• Question 77:

  Which CREATE DATABASE attributes are required?

  A. The database name.

  B. The database name and the redo log file name.

  C. Thedatabase name and the table space name.

  D. The database name and the temporary table space name.

  Correct Answer: A

• Question 78:

  Which statement is true for database users and groups?

  A. All users must belong to admin group.

  B. Creation of users and groupsis not allowed.

  C. Users and groups are local and tied to a particular database.

  D. Users and groups are global and not tied to a particular database.

  Correct Answer: D

• Question 79:

  Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?

  A. Queries on the table will invoke compression.

  B. Queries on date range may involve processing skew.

  C. Queries on date range will utilize only host processing.

  D. Queries on the table will invoke compression on the date columns.

  Correct Answer: B

• Question 80:

  Which statement is true?

  A. All user space is available for database expansion.

  B. Each database is assigned it's own section of disk space.

  C. When creating the database you can specify which disks to use.

  D. When you create a database you can set the maximum space it is allowed to use.

  Correct Answer: A