Free C2090-619 Exam Braindumps


  • Exam Number: C2090-619
  • Provider: IBM
  • Questions: 127
  • Updated On: 23-Jun-2022

QUESTION: 1
Which configuration parameter can toggle the automatic expansion of storage spaces?

A. SP_AUTOGROW
B. SP_AUTO_SPACE
C. SP_AUTOEXPAND
D. SP_EXPAND_ENABLE

Answer(s): C
QUESTION: 2

Which statement is FALSE about dbspace configurable page sizes?

A. Dbspace page size can only be set for non-critical dbspaces.
B. Possible page sizes are multiples of the default page size up to 16 kb.
C. Configure page sizes as close to the backup / restore and network buffer size as possible for
efficient data transfer across the wire.
D. Dbspace page size should be configured to accommodate the greatest number of average
row sizes with a minimum of remainder pages beingused.

Answer(s): C
QUESTION: 3

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?

A. Increase the value of MAX_INCOMPLETE_CONNECTIONS.
B. Increase the value of NUMFDSERVERS and add more poll threads.
C. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.
D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment
variable.

Answer(s): B
QUESTION: 4

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

A. DIRECT_IO
B. DBUPSPACE
C. AUTO_AIOVPS
D. AUTO_READAHEAD

Answer(s): D
QUESTION: 5

Which table attribute defines the percentage of changes (insert/update/delete) threshold to
consider the statistics as stale?

A. STATAUTO
B. STATFORCE
https://Xcerts.com
2