Special Summer Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Note! Following C2090-619 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

IBM Informix 12.10 System Administrator Questions and Answers

Question 1

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.

Buy Now
Question 2

To potentially return unused extent pages to the chunk free list, an Informix administrator would execute which storage optimization operation?

Options:

A.

Shrink

B.

Repack

C.

Compress

D.

Defragment

Question 3

What security role is required for you to create trusted-context objects?

Options:

A.

AAO

B.

DBSA

C.

DBSSO

D.

DBSECADM