Free IBM A2090-619 Exam Dumps Questions & Answers

The IBM Mobile Database is a mobile-optimized version of which IBM product?

• A.  IBM solidDB
• B.  IBM Informix
• C.  IBM DB2
• D.  IBM Cloudscape

You have started a violations table for a target table with a non default name. (For example: "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;").
How can you determine the relationship between the violations table and the target table later?

• A.  Querying sysviolations system catalog table
• B.  Using 'oncheck -pT' command
• C.  Using dbschema utility
• D.  Querying sysdepends system catalog table

Which of the following is NOT possible during a non-root Informix Server installation?

• A.  Role Separation
• B.  Secure the Informix installation directory
• C.  Create users and groups
• D.  Create a database server instance

The following message is received: Lock table overflow - user id user32, session id 54.
What action should be taken to prevent this problem in the future?

• A.  Increase the LOCKS configuration parameter.
• B.  Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.
• C.  Run onclean utility to clear the lock table.
• D.  Turn on the AUTO_TUNE configuration parameter.

Which Informix utility can be used to customize the onconfig file?

• A.  ifxdeploy
• B.  genoncfg
• C.  onparams
• D.  dbaccess