IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 11:

  Which sysmaster table can be queried to find the logging status of a database?

  A. sysdb
  B. sysdblog
  C. sysdatabases
  D. sysdblogstatus
  C. sysdatabases

• Question 12:

  The ability for Informix to allow database access to users without a local operating system account is:

  A. Not allowed.
  B. Allowed and calledefault role-Allowed and called default role.
  C. Allowed and calledapped users-Allowed and called dapped users.
  D. Allowed and calledurrogate users-Allowed and called currogate users.
  C. Allowed and calledapped users-Allowed and called dapped users.

• Question 13:

  Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?

  A. SP_AUTOGROW
  B. SP_THRESHOLD
  C. SP_AUTOEXPAND
  D. SP_CHUNKEXTEND
  B. SP_THRESHOLD

• Question 14:

  Which parameter is used to configure the servers in a high-availability cluster so that transactions complete after failover?

  A. SURVIVAL_TX_ENABLE
  B. FAILOVER_CALLBACK
  C. SURVIVAL_TX_TIMEOUT
  D. FAILOVER_TX_TIMEOUT
  D. FAILOVER_TX_TIMEOUT

• Question 15:

  Which utilities CANNOT be used to migrate an Informix instance from one hardware vendor to a different hardware vendor?

  A. dbacess unload and dbload
  B. onunload and onload
  C. dbexport and dbimport
  D. High Performance Loader (HPL)
  B. onunload and onload

• Question 16:

  What is a requirement for online attach/detach of fragments?

  A. The table cannot have constraints.
  B. The table must have a unique index.
  C. The table must have a remainder fragment.
  D. The table fragmentation scheme and the index fragmentation scheme must be identical.
  D. The table fragmentation scheme and the index fragmentation scheme must be identical.

• Question 17:

  How is the DBSSO group determined on a Unix system with role separation?

  A. It is always the groupinformix.
  B. It is set using theonsecurity command line tool.
  C. It is the group that owns $INFORMIXDIR/dbssodir.
  D. It is the group specified in the DBSSOonconfig parameter.
  C. It is the group that owns $INFORMIXDIR/dbssodir.

• Question 18:

  What does the following SQL statement do? execute function task("reset sysadmin", "admindbs");

  A. Renamessysadmin database to admindbs.
  B. Purges all "mon_*" tables in sysadmin database as user admindbs.
  C. Turns the whole Database Scheduler off and finally dropssysadmin database.
  D. Lockssysadmin database in exclusive mode and recreates it in dbspace admindbs.
  D. Lockssysadmin database in exclusive mode and recreates it in dbspace admindbs.

• Question 19:

  Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary tables be created by default? (Choose three.)

  A. The rootdbspace.
  B. The users' home directory.
  C. The $INFORMIXDIR/tmp directory.
  D. Thedbspace in which the active database was created.
  E. The /tmp directory or PSORT_DBTEMP.
  A. The rootdbspace.
  D. Thedbspace in which the active database was created.
  E. The /tmp directory or PSORT_DBTEMP.

• Question 20:

  What statement about users accessing a Flexible Grid is true?

  A. Every user can execute commands on the Flexible Grid.
  B. Only userinformix can execute commands on a Flexible Grid.
  C. Users have to be authorized to execute Flexible Grid commands.
  D. Commands can only be executed from the node on which the Flexible Grid was created.
  C. Users have to be authorized to execute Flexible Grid commands.