IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 101:

  Which of the following is true about the remote query SELECT * FROM ABC@LMN:XYZ?

  A. SELECT from table ABC at database LMN on server XYZ
  B. SELECT from table ABC at server LMN on database XYZ
  C. SELECT from table LMN on database ABC on server XYZ
  D. SELECT from table XYZ on database ABC at server LMN
  D. SELECT from table XYZ on database ABC at server LMN

• Question 102:

  Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); Which of the following SQL statements will return an error?

  A. INSERT INTO customer VALUES (453);
  B. INSERT INTO customer VALUES (453, '"ABC Company");
  C. INSERT INTO customer (company) VALUES ("ABC Company");
  D. INSERT INTO customer (customer_num, company) VALUES (453, "ABC Company");
  A. INSERT INTO customer VALUES (453);

• Question 103:

  Adding a row to which one of the following tables is required to create a database scheduler job?

  A. ph_task
  B. ph_alert
  C. ph_sensor
  D. ph_scheduler
  A. ph_task

• Question 104:

  Which of the following statement is true of System Monitoring Interface (SMI) tables?

  A. SMI tables store database structures.
  B. Contains tasks used by the database scheduler
  C. SMI tables are also known as System Catalog tables
  D. Contains tables that the database server maintains automatically
  D. Contains tables that the database server maintains automatically

• Question 105:

  Which two statements will update all rows in the customer table? (Choose two.)

  A. update customer set fname = "xyz";
  B. modify customer set fname = "xyz";
  C. modify customer set fname = "xyz" where 1 = 1;
  D. update customer set fname = "xyz" where 1 = 1;
  E. update customer set fname = "xyz" for all;
  A. update customer set fname = "xyz";
  D. update customer set fname = "xyz" where 1 = 1;

• Question 106:

  Which document provides details on preparing an operating system to run Informix?

  A. Machine Notes
  B. System User's Guide
  C. Operating System Guide
  D. Informix Migration Guide
  A. Machine Notes

• Question 107:

  Which one of the following will generate a typical Decision Support System (DSS) type of workload?

  A. Ordering a book from an online retailer
  B. Inquiring usage data for a particular mobile phone user
  C. Bank operation involving transfer of money between two accounts
  D. Generating of a report by a large global retail company to find top selling items by country
  D. Generating of a report by a large global retail company to find top selling items by country

• Question 108:

  Which command listed below can be used to change the state of an operating Informix server?

  A. oninit
  B. onstat
  C. onmode
  D. onparam
  C. onmode

• Question 109:

  Which of the following privileges can NOT be granted to a role?

  A. Type-Level
  B. Table-Level
  C. Routine-Level
  D. Database-Level
  D. Database-Level

• Question 110:

  Which two SQL API commands can be used to create a 10 MB dbspace? (Choose two.)

  A. task ( )
  B. admin ( )
  C. oncmd ( )
  D. ifxcreate ( )
  E. oncreate ( )
  A. task ( )
  B. admin ( )