最新のA2090-919問題集で試験を準備する

IBM A2090-919 試験概要:

IBM A2090-919 試験シラバストピック:

IBM Assessment: System Administrator for Informix Server 11.70 認定 A2090-919 試験問題：

1. Under which condition can table fragments NOT be eliminated during query processing?

A) Tables with non-overlapping fragments and an equality query predicate.
B) Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.
C) Tables with round-robin distribution scheme and a range query predicate.
D) Tables with non-overlapping fragments on a single column and a range query predicate.

2. Given the following SQL statement:

WHEN MATCHED THEN DELETE What does the merge statement do?

A) Deletes rows in tab2 that match the condition col1 = c1.
B) Deletes rows in tab1 that match the condition col1 = c1 and insert rows in tab1 from those in tab2 that do not match the condition.
C) Deletes rows in tab1 that match the condition col1 = c1 and deletes rows in tab2 that do not match the condition col1 = c1.
D) Deletes rows in tab1 that match the condition col1 = c1.

3. Identify a scenario when you CANNOT use in-place migration?

A) When you want to use new configuration features in the new Informix version.
B) When you want to migrate from a 32-bit to a 64-bit port of Informix.
C) When you want to defragment some of the heavily fragmented tables.
D) When you want to change database locale.

4. Which of the following activities does the Secure-Auditing Facility NOT monitor and record?

A) Specific users.
B) Specific tables.
C) Specific DML operations.
D) Specific rows.

5. Given the following SQL statement:

What does the merge statement do?

A) Deletes rows from tab2 and updates rows in tab1 that match the condition col1 = c1 by adding the c2 column value to the col2 column value of corresponding rows in tab1.
B) For each row that matches the condition col1 = c1, it inserts a new row in tab1 with the sum of corresponding c2 and col2 column values.
C) For the rows that match the condition col1 = c1, it adds the the c2 column value to the col2 column value and updates corresponding rows in tab1.
D) For the rows that match the condition, col1 = c1, it adds the col2 column value to the c2 column value and updates corresponding rows in tab2.

質問と回答：