IBM IBM Certifications C2090-619 Questions & Answers

• Question 81:

  Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?

  A. -1

  B. 0

  C. 1

  D. 30

  Correct Answer: B

• Question 82:

  Which statement is true for starting Connection Manager?

  A. Only user root and informix.

  B. Any user of the DBSA group.

  C. Any user who is granted privileges to connect to the sysadmin database.

  D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

  Correct Answer: D

• Question 83:

  store1, store2, store3 and store4 are defined as four servers participating in a GRID.

  

  Which statement is true?

  A. The SELECT query is not a GRID query.

  B. The SELECT query will return results from all grid servers.

  C. The SELECT query will return results from store1 and store2.

  D. The SELECT query will return results from store3 and store4.

  Correct Answer: D

• Question 84:

  Which is a valid Pluggable Authentication Module (PAM) mode in Unix?

  A. Login mode

  B. Client mode

  C. Server mode

  D. Password mode

  Correct Answer: D

• Question 85:

  Which statement accurately describes the mapped user functionality in Informix?

  A. The DBSA can control the access to the database at the table level by creating different security labels for each user.

  B. The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessaryprivileges.

  C. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the hostcomputer.

  D. The DBSA can grant access to the database server to users of the host computer operating system by implementing different authenticationmechanisms for each user.

  Correct Answer: C

• Question 86:

  What security role is required for you to create trusted-context objects?

  A. AAO

  B. DBSA

  C. DBSSO

  D. DBSECADM

  Correct Answer: D

• Question 87:

  Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)

  A. On-disk encryption

  B. Enterprise Replication

  C. Column level encryption

  D. High-Availability Data Replication

  E. Server-to-server distributed query communication

  Correct Answer: BD

• Question 88:

  Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.

  A. All users with the EXTEND role can grant it to other users.

  B. All users with the default role can register external routines.

  C. All users can create external routines in the database server.

  D. All users with the EXTEND role can register external routines.

  Correct Answer: D

• Question 89:

  Which statement accurately describes the selective row-level auditing feature in Informix?

  A. Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.

  B. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.

  C. Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.

  D. Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

  Correct Answer: B

• Question 90:

  Given these statements are executed: which statement is true?

  

  A. The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.

  B. The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator(IWA).

  C. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and OLAP expressions are evaluated by Informix database server.

  D. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAPexpressions are evaluated by Informix Warehouse Accelerator (IWA).

  Correct Answer: C