IBM IBM Certifications C2090-619 Questions & Answers

• Question 111:

  What data migration tool(s) should be used to load data from a non-Informix data source?

  A. dbimport

  B. onload and dbload

  C. dbload and High Performance Loader

  D. onload and High Performance Loader

  Correct Answer: C

• Question 112:

  Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)

  A. Byte

  B. Shared

  C. Update

  D. Exclusive

  E. Promotable

  Correct Answer: BD

• Question 113:

  Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?

  A. sysdistrib

  B. systables

  C. sysindexes

  D. syscolumns

  Correct Answer: A

• Question 114:

  Which SQL statement is valid to monitor database server sessions?

  A. EXECUTE FUNCTION task ("onstat","-g ses");

  B. EXECUTE FUNCTION task ("view sessions","all");

  C. EXECUTE FUNCTION task ("check sessions","all");

  D. EXECUTE FUNCTION task ("check server","sessions");

  Correct Answer: A

• Question 115:

  Given the following:

  

  How many locks will be used on tab1 to run the query?

  A. 0

  B. 1

  C. 2

  D. Depends on the number of index pages accessed

  Correct Answer: A

• Question 116:

  Which Informix utility is used to print information about runtime statistics for all threads in the server?

  A. onstat -g sta

  B. onstat -g act

  C. onstat -g rea

  D. onstat -g cpu

  Correct Answer: D

• Question 117:

  You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?

  A. stores:sysusers

  B. sysmaster:sysroles

  C. sysuser:sysroleauth

  D. sysmaster:sysusers

  Correct Answer: A

• Question 118:

  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. Run onclean utility to clear the lock table.

  B. Increase the LOCKS configuration parameter.

  C. Turn on the AUTO_TUNE configuration parameter.

  D. Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.

  Correct Answer: B

• Question 119:

  In which table can you find a history of all SQL Administration API functions executed in the last 30 days?

  A. sysadmin:admin_history

  B. sysmaster:admin_history

  C. sysadmin:command_history

  D. sysmaster:command_history

  Correct Answer: C

• Question 120:

  Which Informix utility can be used to display contents of logical-log files, either from disk or from backup?

  A. onlog

  B. onclean

  C. ondblog

  D. onspaces

  Correct Answer: A