IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 41:

  Which fragmentation strategy is capable of generating new fragments automatically?

  A. Fragment by List
  B. Fragment by Range
  C. Fragment By Expression
  D. Fragment by Round Robin
  B. Fragment by Range

• Question 42:

  Assuming network connectivity between two Informix instances, which file may need additional configuration to allow distributed queries?

  A. sqlhosts
  B. /etc/services
  C. $ONCONFIG
  D. /etc/hosts.equiv
  D. /etc/hosts.equiv

• Question 43:

  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.
  C. Configure page sizes as close to the backup / restore and network buffer size as possible for efficient data transfer across the wire.

• Question 44:

  Which statement is true regarding default roles?

  A. The DBSA can define a default role to assign only to the PUBLIC group for a particular database.
  B. The privileges associated with a default role takes precedence over the privileges granted to an individual user.
  C. The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.
  D. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.
  C. The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.

• Question 45:

  Which statement is FALSE about Informix Automatic checkpoint Feature?

  A. Automatic checkpoints cause less logical log activity.
  B. Automatic checkpoints try to avoid transaction blocking.
  C. Automatic checkpoints cause the database server to trigger more frequent checkpoints.
  D. Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm or onmode -wf.
  A. Automatic checkpoints cause less logical log activity.

• Question 46:

  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
  C. SP_AUTOEXPAND

• Question 47:

  Which log file CANNOT be rotated using the default "message log rotate" SQL admin command?

  A. audit log
  B. message log
  C. onbar debug log
  D. onbar activity log
  A. audit log

• Question 48:

  Which two DataBlade extensions can be automatically registered? (Choose two.)

  A. Web DataBlade
  B. Spatial DataBlade
  C. TimeSeries DataBlade
  D. Excalibur Text DataBlade
  E. High Performance Loader DataBlade
  B. Spatial DataBlade
  C. TimeSeries DataBlade

• Question 49:

  What is the primary benefit of a Storage Pool?

  A. It allows data to be shared across instances.
  B. It allows data to be shared across dbspaces.
  C. It allows space to automatically be added to dbspaces.
  D. It allows space to be reserved for critical database operations.
  C. It allows space to automatically be added to dbspaces.

• Question 50:

  Which two statements are true?

  A. Temporary dbspaces can have different page sizes.
  B. Separate temporary dbspaces are required for each buffer pool.
  C. DBSPACETEMP dbspaces can be temporary or standard dbspaces.
  D. If rootdbs is mirrored then all the temporary spaces must be mirrored.
  E. If DBSPACETEMP is not configured then temporary space will never be used.
  A. Temporary dbspaces can have different page sizes.
  C. DBSPACETEMP dbspaces can be temporary or standard dbspaces.