IBM Assessment: System Administrator for Informix Server 11.70 - A2090-919 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 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 non-overlapping fragments on a single column and a range query predicate. C. Tables with round-robin distribution scheme and a range query predicate. D. Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.

Discussion 0

Correct Answer: C Vote an answer

Question 2

Given the following SLA definition:
SLA group_1=HDR+(inst_2+inst_3)+SDS
How will new connections be routed through the SLA?

A. The HDR instance first, load balanced between inst_2 and inst_3, then to any SD secondary instance. B. Load balanced between all secondary instances. C. The HDR instance first, then inst_2, followed by inst_3, finally to any SD secondary instance. D. Load balanced between inst_2 and inst_3, then either HDR or any SD secondary instance.

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which of the following is NOT a step in setting up HDR for the first time?

A. Use onmode -d to specify the secondary instance name. B. Take a level 0 backup of the primary. C. Execute a physical restore on the secondary. D. Use oninit -v to bring up the secondary.

Discussion 0

Correct Answer: D Vote an answer

Question 4

Which statement about automatic space management is true?

A. Only unmirrored spaces can be extended. B. The time interval for low storage space checks is not user configurable. C. Mirrored and unmirrored spaces can be extended. D. Spaces cannot be extended manually.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which role can create, alter, or delete trusted context objects?

A. DBA B. DBSSO C. DBSA D. DBSECADM

Discussion 0

Correct Answer: D Vote an answer

Question 6

Fragment level statistics are NOT supported with which fragmentation strategy?

A. Expression fragmentation. B. List fragmentation. C. Round-robin fragmentation. D. Interval fragmentation.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

Given the following customer table:

A. 3 B. 2 C. 1 D. 4

Discussion 0

Correct Answer: B Vote an answer