IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 21:

  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.
  A. Theuserthread is waiting on a condition.

• Question 22:

  When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.) executefunction sysadmin:task("defragment table","customer"); executefunction sysadmin:task("table repack", "customer");

  A. Fragments of a table will be combined.
  B. Rows will be moved to the beginning of table.
  C. Given sufficient resources the number of extents in the table will be reduced.
  D. Free space at the end of the table will be released to thedbspace for other tables to use.
  E. The table will be locked preventing inserts from happening for the duration of the commands.
  B. Rows will be moved to the beginning of table.
  C. Given sufficient resources the number of extents in the table will be reduced.

• Question 23:

  Which role can create, alter, or delete trusted context objects?

  A. DBA
  B. DBSA
  C. DBSSO
  D. DBSECADM
  D. DBSECADM

• Question 24:

  Which CANNOT be used to move compressed data from one database to another?

  A. dbload
  B. dbexport
  C. onunload
  D. High-Performance Loader
  C. onunload

• Question 25:

  For a given procedure name, what is the objective of the SQL query shown below?

  

  A. The query returns the ordered text form of the specified procedure body.
  B. The query returns the ordered compiled form of the specified procedure body.
  C. The query returns both ordered text and ordered compiled form of the specified procedure body.
  D. The query returns neither the ordered text nor the ordered compiled form of the specified procedure body.
  A. The query returns the ordered text form of the specified procedure body.

• Question 26:

  The following shrink command has what effect on the customer table? execute function sysadmin:task("table shrink","customer")

  A. Moves all rows to the beginning of the table while users can modify the table.
  B. Locks the table in exclusive mode and moves all rows to the beginning of the table.
  C. Locks the table in exclusive mode and releases all free space at the end of the table.
  D. Releases all free space at the end of the table to thedbspace while users can modify the table.
  D. Releases all free space at the end of the table to thedbspace while users can modify the table.

• Question 27:

  Which is NOT valid information in the SQLHOSTS connectivity file (or on windows the SQLHOSTS registry key)?

  A. Connection type.
  B. Number of listener threads.
  C. Host name and service name.
  D. Database server name or alias.
  B. Number of listener threads.

• Question 28:

  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.
  A. Enter the CSM name in thesqlhosts file.
  C. Define the CSM in the concsm.cfg configuration file.

• Question 29:

  Which utility requires database logging be turned off to load a table?

  A. load
  B. dbload
  C. onload
  D. dbimport
  C. onload

• Question 30:

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

  A. dbinfo
  B. onstat
  C. dbschema
  D. onmachinfo
  B. onstat