Complete C2090-619 IBM Materials

IBM Informix 12.10 System Administrator Questions and Answers

Question 13

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

Options:

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

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

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

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

Question 14

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

Options:

Shrink

Repack

Compress

Defragment

Question 15

The DBA wants to define a replicate as follows:

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

Options:

The table table1 should have col1 as its primary key.

The table table1 should have CRCOLS shadow columns.

The table table1 should have a constraint on column col1.

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

Question 16

An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?

Options:

Increase the value of MAX_INCOMPLETE_CONNECTIONS.

Increase the value of NUMFDSERVERS and add more poll threads.

Increase the value of NUMFDSERVERS and increase the number of MSC VPs.

Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.

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

IBM Informix 12.10 System Administrator Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer: