C2090-919 by IBM Valid Free Exam Practice Test

Question 1

Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?

A. To avoid transaction blocking during checkpoints. B. To avoid LRU flushes. C. To ensure the buffer pool is always available. D. To ensure the onstat -g ckp report is accurate.

Correct Answer: A

Question 2

Which statement about updating statistics is NOT true?

A. Data distributions are updated every time UPDATE STATISTICS LOW is executed. B. UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable. C. UPDATE STATISTICS HIGH scans the entire table. D. An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE.

Correct Answer: A

Question 3

Consider the following selective row-level auditing example:

How many entries will be added to the audit file?

A. 3 B. 5 C. 8 D. 0

Correct Answer: B

Question 4

Given the SQL explain output of this star join query, which is the fact table?

IBM 000-919 : Practice Test

A. customer B. sales C. product D. region

Correct Answer: B

Question 5

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, then inst_2, followed by inst_3, finally to any SD secondary instance. B. Load balanced between inst_2 and inst_3, then either HDR or any SD secondary instance. C. Load balanced between all secondary instances. D. The HDR instance first, load balanced between inst_2 and inst_3, then to any SD secondary instance.

Correct Answer: D

Question 6

Which storage space should be used to store columns defined as a BLOB or a CLOB?

A. sbspace B. extspace C. dbspace D. blobspace

Correct Answer: A

Question 7

By default, the alarm program gets executed for which event(s)?

A. Only for events with Severity code greater than 1. B. Only for events with Severity code 1. C. All events. D. Only for events with Severity code 5.

Correct Answer: A

Question 8

What is a requirement for online attach/detach of fragments?

A. The table must have a unique index. B. The table cannot have constraints. C. The table fragmentation scheme and the index fragmentation scheme must be identical. D. The table must have a remainder fragment.

Correct Answer: C

Question 9

Which two onconfig parameters can be set to backup/restore to/from a cloud storage location? (Choose two.)

A. LTAPEBLK B. TAPEBLK C. LTAPEDEV D. BAR_BSALIB_PATH E. TAPEDEV

Correct Answer: C,E

Question 10

When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.)
execute function sysadmin:task("defragment table","customer"); execute function sysadmin:task("table repack", "customer");

A. Rows will be moved to the beginning of table. B. Free space at the end of the table will be released to the dbspace for other tables to use. C. Fragments of a table will be combined. D. Given sufficient resources the number of extents in the table will be reduced. E. The table will be locked preventing inserts from happening for the duration of the commands.

Correct Answer: A,D

IBM Informix 11.70 System Administrator - C2090-919 Exam Practice Test