IBM IBM Certified System Administrator C2090-919 Questions & Answers

• Question 41:

  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.

  Correct Answer: D

• Question 42:

  Which user isolation level may cause concurrency problems with SELECT statements?

  A. Dirty Read

  B. Committed Read

  C. Dirty Read Last Committed

  D. Committed Read Last Committed

  Correct Answer: B

• Question 43:

  Which onstat command returns an accurate free count of blobspace pages?

  A. onstat -d

  B. onstat -g blb

  C. onstat -d update

  D. onstat -d blobinfo

  Correct Answer: C

• Question 44:

  Which command line utility displays real time statistics about the instance?

  A. dbinfo

  B. onstat

  C. dbschema

  D. onmachinfo

  Correct Answer: B

• Question 45:

  If SQLTRACE is enabled, what information is displayed by this statement? select max(sql_runtime) from syssqltrace;

  A. The SQL statement with the least wait time.

  B. The SQL statement with the least I/O wait time.

  C. The SQL statement with the most I/O wait time.

  D. The SQL statement with the most execution time.

  Correct Answer: D

• Question 46:

  When running an onstat -u, what does a 'Y' in the first column of the flags signify?

  A. Theuserthread is waiting on a condition.

  B. Theuserthread is waiting for end user I/O to complete.

  C. Theuserthread is waiting for a thread to yield a cpu vp.

  D. Theuserthread is waiting for a thread with a higher priority.

  Correct Answer: A

• Question 47:

  By default, the alarm program gets executed for which event(s)?

  A. All events.

  B. Only for events with Severity code 1.

  C. Only for events with Severity code 5.

  D. Only for events with Severity code greater than 1.

  Correct Answer: D

• Question 48:

  What does this user-defined task/sensor do?

  

  A. Sensor that stores checkpoint information (onstat -g ckp) in the system.

  B. Task that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday.

  C. Task that forces a checkpoint every 20 minutes from 10am to 10pm, Monday to Friday.

  D. Sensor that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday.

  Correct Answer: B

• Question 49:

  What two conditions must be met for direct I/O to occur? (Choose two.)

  A. When the I/O is to raw disk space.

  B. When the I/O is to cooked disk space.

  C. When the table is too big to fit in thebufferpool.

  D. When doing I/O operations on temporarydbspaces.

  E. When the DIRECT_IO configuration parameter is set to 1.

  Correct Answer: BE

• Question 50:

  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)

  Correct Answer: B