IBM Assessment: System Administrator for Informix Server 11.70 - A2090-919 Free Exam Questions

A. A NULL fragment is allowed.

B. Fragments cannot be overlapping.

C. A remainder fragment is allowed.

D. A fragment key can have only a single column.

A. Deletes rows in tab2 that match the condition col1 = c1.

B. Deletes rows in tab1 that match the condition col1 = c1.

C. 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.

D. Deletes rows in tab1 that match the condition col1 = c1 and deletes rows in tab2 that do not match the condition col1 = c1.

A. LTAPEDEV

B. LOGSIZE

C. BAR_PROGRESS_FREQ

D. PHYSFILE

E. BUFFERPOOL

A. External Tables

B. Temporary DBSpaces

C. Logical Log

D. Physical Log

A. extspace

B. blobspace

C. dbspace

D. sbspace

A. The maximum time allowed for distributed stored procedures to complete.

B. The maximum amount of wait time for a reply from an H/A cluster secondary.

C. The maximum time a user session will wait for a space extension to complete.

D. The maximum amount of wait time permitted before an automatic space allocation will begin.

A. Allowed and called urrogate users?Allowed and called ?urrogate users?

B. Not allowed.

C. Allowed and called apped users?Allowed and called ?apped users?

D. Allowed and called efault role?Allowed and called ?efault role?

A. Task that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday.

B. Task that forces a checkpoint every 20 minutes from 10am to 10pm, Monday to Friday.

C. Sensor that stores checkpoint information (onstat -g ckp) in the system.

D. Sensor that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday.