Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Sure Pass Exam C2090-619 PDF

Page: 5 / 5
Total 130 questions

IBM Informix 12.10 System Administrator Questions and Answers

Question 17

Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?

Options:

A.

DIRECT_IO

B.

DBUPSPACE

C.

AUTO_AIOVPS

D.

AUTO_READAHEAD

Question 18

The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

Options:

A.

The table has a ROWID shadow column.

B.

The table has a Fragment By Range index.

C.

The table has a Unique Key being used by ER.

D.

The Fragment Key is defined with multiple columns.

E.

The Primary Key for the table is referenced by a foreign key constraint.

Question 19

Where must the HA_FOC_ORDER configuration parameter be set?

Options:

A.

Any server in the cluster.

B.

The primary server only.

C.

The SDS secondary only.

D.

The HDR secondary only.

Page: 5 / 5
Total 130 questions