IBM IBM Certifications C2090-619 Questions & Answers

• Question 101:

  Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?

  A. onbar -E

  B. dbexport

  C. onsmsync

  D. ontape -exp

  Correct Answer: C

• Question 102:

  Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

  A. ANSI and non-ANSI

  B. Buffered and Unbuffered

  C. Buffered and Non-logging

  D. Non-logging and Unbuffered

  E. Non-logging and Non-logging

  Correct Answer: BE

• Question 103:

  Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured? (Choose two.)

  A. Memory page size.

  B. Total number of available semaphores.

  C. Lower-boundary address for shared memory.

  D. Total memory presented to the operating system.

  E. Maximum operating-system shared-memory segment size.

  Correct Answer: CE

• Question 104:

  Which two statements are true? (Choose two.)

  A. Logical log files must always reside in rootdbs.

  B. Having too little log space does not affect performance.

  C. Having too much log space does not affect performance.

  D. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.

  E. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.

  Correct Answer: CD

• Question 105:

  When configuring Informix server for DRDA connection, which statement is true?

  A. The connection protocol must be drsoctcp.

  B. The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.

  C. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.

  D. The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

  Correct Answer: C

• Question 106:

  Which threshold setting applies when configuring automatic memory management?

  A. SHMTOTAL

  B. BUFFERPOOL

  C. SHMVIRTSIZE

  D. DS_TOTAL_MEMORY

  Correct Answer: A

• Question 107:

  Which is NOT a component of the IBM Mobile Database offering?

  A. IBM DB2

  B. IBM Informix

  C. IBM solidDB

  D. IBM InfoSphere Warehouse

  Correct Answer: D

• Question 108:

  During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?

  A. User local shell, system global

  B. System global, user local shell

  C. System global, user local shell, onconfig file

  D. Onconfig file, user local shell, system global

  Correct Answer: D

• Question 109:

  Role separation provides checks and balances to improve the security of your event-auditing procedures. Which two roles must be associated with group IDs to enable role separation? (Choose two.)

  A. DBSEC: DB Security Officer

  B. AAO: Auditing Analysis Officer

  C. DBASO: DB Audit and Security Officer

  D. DBAMO: DB Audit Management Officer

  E. DBSSO: Database System Security Officer

  Correct Answer: BE

• Question 110:

  Which statement about DataBlade modules is true?

  A. All DataBlades located in the $INFORMIXDIR/extend are automatically registered.

  B. All built-in extensions are automatically registered when the extension is first accessed.

  C. All built-in extensions are automatically registered each time the database sever is started.

  D. All built-in extensions are automatically registered when the database server is first initialized.

  Correct Answer: B