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

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 DBA wants to define a replicate as follows:

Which condition must be true for the command to execute successfully?

Options:

A.

The table table1 should have col1 as its primary key.

B.

The table table1 should have CRCOLS shadow columns.

C.

The table table1 should have a constraint on column col1.

D.

The table table1 should have an unique index on column col2.

Buy Now
Question 2

Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?

Options:

A.

The temp table will be created in datadbs1.

B.

The temp table will be created in root dbspace.

C.

The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.

D.

The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

Question 3

Which statement is true regarding the selective row-level auditing feature in Informix?

Options:

A.

You can create audit masks corresponding to row-level events of a specific table.

B.

Selective row-level auditing must be explicitly turned on using the onshowaudit utility.

C.

When you create a table, you can specify if row-level auditing should be enabled for the table.

D.

When you create a database, you can specify if row-level auditing should be enabled for all the tables within the database.