IBM IBM Certified System Administrator C2090-919 Questions & Answers

• Question 101:

  Given the following SQL command where the DBSPACETEMP onconfig and environment variables are set to valid dbspaces:

  createtemp table mytemp (columns) with no log;

  inwhat order will the instance evaluate where to place this table?

  A. DBSPACETEMP environment variable, rootdbspace, dbspace where the database was created, DBSPACETEMP onconfig parameter.

  B. DBSPACETEMP environment variable, DBSPACETEMPonconfig parameter, dbspace where the database was created, root dbspace.

  C. DBSPACETEMPonconfig parameter variable, DBSPACETEMP environment variable, root dbspace, dbspace where the database was created.

  D. DBSPACETEMPonconfig parameter variable, root dbspace, dbspace where the database was created, DBSPACETEMP environment variable.

  Correct Answer: B

• Question 102:

  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.

  Correct Answer: ADE

• Question 103:

  What two onconfig parameters will help improve performance of new network connections? (Choose two.)

  A. NETTYPE

  B. VPCLASS

  C. NS_CACHE

  D. FET_BUF_SIZE

  E. NUMFDSERVERS

  Correct Answer: CE

• Question 104:

  Which two corrective actions may be taken if following message is logged in the online message log during a failed attempt to bring an instance online? (Choose two)

  18:15:44

  Size of resident + virtual segments 100000KB + 60000KB > 150000KB

  18:15:44

  total allowed by configuration parameter SHMTOTAL

  A.

  Decrease SHMADD

  B.

  Increase SHMTOTAL

  C.

  Decrease SHMBASE

  D.

  Increase SHMVIRTSIZE

  E.

  Decrease buffer pool size

  Correct Answer: BE

• Question 105:

  Which of the following privileges is NOT valid for a table fragment?

  A. ALL

  B. INSERT

  C. UPDATE

  D. CREATE INDEX

  Correct Answer: D

• Question 106:

  Which statement regarding default roles is true?

  A. An administrator 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. An administrator 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.

  Correct Answer: C

• Question 107:

  Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?

  A. To avoid LRU flushes.

  B. To ensure the buffer pool is always available.

  C. To ensure theonstat -g ckp report is accurate.

  D. To avoid transaction blocking during checkpoints.

  Correct Answer: D

• Question 108:

  Which statement about the scope of UPDATE STATISTICS is true?

  A. If the FOR PROCEDURE keywords are included but the name of any SPL routine is not specified, an error will be returned.

  B. If the FOR TABLE keywords are used without specifying the name or synonym of a table, the database will not recalculate distributions for any table in the current database.

  C. If the FOR TABLE keywords are specified with a table but without specifying a list of columns, the database server will not recalculate distributions on all of the columns of the specified table.

  D. If the FOR PROCEDURE specification, Table and Column Scope, and Resolution clauses are NOT included, then the statistics are updated for every table and SPL routine in the current database.

  Correct Answer: D

• Question 109:

  Which statement about mapped user functionality is true?

  A. Mapped users cannot execute distributed operations.

  B. Mapped users are allowed to run with multiple names.

  C. The DBSA can control the access to tables at a row level using security labels.

  D. The DBSA can grant database server access to externally authenticated users with no local account.

  Correct Answer: D

• Question 110:

  To enable network encryption, what two steps must the administrator complete? (Choose two.)

  A. Enter the CSM name in thesqlhosts file.

  B. Set the IFX_ENCCSMonconfig parameter to 1.

  C. Define the CSM in the concsm.cfg configuration file.

  D. Enter the CSM name in theonconfig NETTYPE parameter.

  E. Set the environment variable ENCCSMCFG to the name of the CSM.

  Correct Answer: AC