IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 1:

  Which of these commands will create a table containing a column that will be automatically populated with a numeric value starting from an initial value of 2301 and incremented as rows are inserted?

  A. CREATE TABLE customer (cust_num SERIAL(2301), ?;
  B. CREATE TABLE customer (cust_num SERIAL INIT 2301,?;
  C. CREATE TABLE customer (cust_num INT SET SERIAL 2301,?;
  D. CREATE TABLE customer (cust_num SERIAL,? SET SERIAL 2301;
  A. CREATE TABLE customer (cust_num SERIAL(2301), ?;

• Question 2:

  In which two places may a function be used in a SELECT statement? (Choose two.)

  A. in a subquery
  B. in a HAVING clause
  C. in a GROUP BY clause
  D. in the ORDER BY clause
  E. in the select (or projection) list
  A. in a subquery
  E. in the select (or projection) list

• Question 3:

  Which of the following modes is NOT supported by Informix?

  A. On-Line
  B. Quiescent
  C. Replication
  D. Administration
  C. Replication

• Question 4:

  What is the only isolation level available on an unlogged database?

  A. Dirty Read
  B. Cursor Stability
  C. Committed Read
  D. Repeatable Read
  A. Dirty Read

• Question 5:

  When encountering an assertion failure or performance issue, which Informix utility, when run by the DBA, collects and bundles the basic diagnostic data?

  A. ontape
  B. onmode
  C. ifxcollect
  D. onparams
  C. ifxcollect

• Question 6:

  Which command could be used to display the definition of user-defined and complex data types?

  A. onstat -g smb
  B. oncheck -cc database_name
  C. oncheck -pB database_name
  D. dbschema -u all -d database_name
  D. dbschema -u all -d database_name

• Question 7:

  Which of the following is true about star schemas?

  A. A star schema is optimal for OLTP systems.
  B. A star schema is also known as a 3rdNormal Form schema.
  C. A star schema is associated with master-detail relationships between tables.
  D. A star schema is not necessarily a snowflake schema, but a snowflake schema is always a star schema.
  D. A star schema is not necessarily a snowflake schema, but a snowflake schema is always a star schema.

• Question 8:

  Which of the following environment variables allow an application to specify formatting of locale-sensitive data such as of date and currency values?

  A. DB_LOCALE
  B. GLS_LOCALE
  C. CLIENT_LOCALE
  D. SERVER_LOCALE
  C. CLIENT_LOCALE

• Question 9:

  What is true about poll threads?

  A. poll threads always run on a CPU vp
  B. poll threads always run on a NET vp
  C. poll threads always run on an ADM vp
  D. poll threads can be configured on a CPU or NET vp
  D. poll threads can be configured on a CPU or NET vp

• Question 10:

  In what way is Enterprise Replication (ER) replication different from High-Availability Cluster (HAC) replication?

  A. All data types are replicated.
  B. The data to be replicated is defined at an instance level of granularity.
  C. The data to be replicated can be defined at a column level of granularity.
  D. The data to be replicated can not include simple blobs stored in simple blobspaces.
  C. The data to be replicated can be defined at a column level of granularity.