IBM IBM Certifications P2090-047 Questions & Answers

• Question 71:

  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 one base table in the FROM clause.

  Correct Answer: DE

• Question 72:

  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

• Question 73:

  When are zonemaps initially created for a table?

  A. nzbackup

  B. nzreclaim

  C. CREATE TABLE

  D. ALTER TABLE ADD ZONEMAPS

  Correct Answer: C

• Question 74:

  Which of the following is a valid datatype definition?

  A. TEXT

  B. CLOB

  C. CHAR(64000)

  D. NUMERIC(1,38)

  Correct Answer: C

• Question 75:

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

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

  A. BIGINT

  B. FLOAT8

  C. NUMERIC(38,0)

  D. VARCHAR(256)

  Correct Answer: A

• Question 77:

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

  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

• Question 79:

  You have created a group GroupA with JOB MAXIMUM of 4, which statement is true?

  A. No more than 4 users can be assigned to GroupA.

  B. If users in GroupA submit more than 4 queries they will fail.

  C. If users in GroupA submit more than 4 queries, then they will queue in order.

  D. The job maximum cannot be less than the default concurrent query limit of 48.

  Correct Answer: C

• Question 80:

  Which CREATE DATABASE attributes are required?

  A. The database name.

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

  C. The database name and the table space name.

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

  Correct Answer: A