IBM IBM Certifications P2090-050 Questions & Answers

• Question 51:

  What is the maximum number of columns that can participate in a distribution key?

  A. One

  B. Four

  C. Unlimited

  D. Depends on the number of columns of integer datatype.

  Correct Answer: B

• Question 52:

  If data is being nzload'ed into TableA, which of the following operations will be blocked until the load has completed?

  A. A DELETE from TableA

  B. A SELECT from TableA

  C. A TRUNCATE of TableA

  D. An nzbackup of the database in which TableA resides

  Correct Answer: C

• Question 53:

  What two conditions must be met to achieve a collocated join between two tables? (Choose two.)

  A. Both tables have primarykeys defined.

  B. Both join columns have the same name.

  C. Both tables must be distributed on random.

  D. Both join columns have identical data types.

  E. Both tables must be distributed on their join column.

  Correct Answer: DE

• Question 54:

  Which statement is true about a simple load using external tables?

  A. The load can be configured to automatically continue toload if the S-Blade resets or fails.

  B. The load can be configured to automatically create a backup file of the table being loaded.

  C. The load can be configured to automatically create a duplicate copy of the table being loaded.

  D. The load can be configured to automatically remove duplicate rows from the table being loaded.

  Correct Answer: A

• Question 55:

  What is the state of the two hosts on a properly functional PureData System for Analytics Appliance?

  A. Active - Active

  B. Active - Stand by

  C. Stand by -Backup

  D. Stand by - Passive

  Correct Answer: B

• Question 56:

  What is the function of the Distributed Replicated BlockDevice (DRBD)?

  A. High Availability

  B. Load Balancing

  C. High Concurrency

  D. Work Load Management

  Correct Answer: A

• Question 57:

  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

  Correct Answer: C

• Question 58:

  Which clause CANNOT be used with a CREATE VIEW statement?

  A. SUM ()

  B. GROUP BY

  C. ORDER BY

  D. OUTER JOIN

  Correct Answer: C

• Question 59:

  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

  Correct Answer: BD

• Question 60:

  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.

  Correct Answer: B