IBM C2090-558 Online Practice Questions and Exam Preparation

IBM C2090-558 Online Questions & Answers

• Question 41:

  Which of the following utilities can be used for quick installation of pre-configured IBM Informix instances to many computers?

  A. Ontape utility
  B. Snapshot utility
  C. Archecker utility
  D. Deployment utility
  D. Deployment utility

• Question 42:

  Which two operations are performed with the onspaces command? (Choose two.)

  A. Add space to the server.
  B. Compress server space.
  C. Encrypt the server space.
  D. Remove space from the server.
  E. Restrict access to the server space.
  A. Add space to the server.
  D. Remove space from the server.

• Question 43:

  Why would you want to create a table with a lock mode row as opposed to a lock mode page?

  A. to reduce disk I/O
  B. to keep more information in memory for each locked row
  C. to increase concurrency among multiple users on the same table
  D. to reduce the number of locks when accessing rows out of the table
  C. to increase concurrency among multiple users on the same table

• Question 44:

  Click the Exhibit button.

  

  The query.sql file contains the information shown in the exhibit. The following command is run: dbaccess ?query.sql How many rows will be returned by the select query?

  A. 1
  B. 2
  C. 3
  D. 4
  B. 2

• Question 45:

  Which of the following can be used to create and drop logical logs?

  A. onlog
  B. ondblog
  C. onspaces
  D. onparams
  D. onparams

• Question 46:

  Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?

  A. Use a trigger.
  B. Create a foreign key.
  C. Use a nightly batch process.
  D. Define a task in the sysadmin database.
  A. Use a trigger.

• Question 47:

  When storing string "ABCD" in a column, which of the following data types will result in a string stored with 2 padded spaces?

  A. VARCHAR (6)
  B. VARCHAR (4,2)
  C. VARCHAR (8,6)
  D. VARCHAR (6,8)
  C. VARCHAR (8,6)

• Question 48:

  Which of the following is true about system catalog tables access?

  A. Only user informix can read system catalog tables
  B. Only system administrators can read system catalog tables
  C. Only database administrators can read system catalog tables
  D. Any user that can connect to the database can read system catalog tables
  D. Any user that can connect to the database can read system catalog tables

• Question 49:

  Which command would you execute to restore to a specific moment-in-time?

  A. onbar -t timestamp
  B. onbar -r -log lognum
  C. onbar -r -t timestamp
  D. onbar -r -l timestamp
  C. onbar -r -t timestamp

• Question 50:

  Which one of the following is most suitable for scheduling the periodic collection of data about an instance?

  A. Sensor
  B. Trigger
  C. Stored Procedure
  D. User Defined Routine
  A. Sensor