IBM IBM Certifications C2090-619 Questions & Answers

• Question 21:

  The DBA wants to define a replicate as follows: Which condition must be true for the command to execute successfully?

  

  A. The table table1 should have col1 as its primary key.

  B. The table table1 should have CRCOLS shadow columns.

  C. The table table1 should have a constraint on column col1.

  D. The table table1 should have an unique index on column col2.

  Correct Answer: D

• Question 22:

  Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

  A. cdr start

  B. cdr sync

  C. cdr realize

  D. cdr remaster

  Correct Answer: D

• Question 23:

  Which parameter is used to enable transactions to complete after failover of the primary server?

  A. HA_FOC_ORDER

  B. FAILOVER_CALLBACK

  C. CLUSTER_TXN_SCOPE

  D. FAILOVER_TX_TIMEOUT

  Correct Answer: D

• Question 24:

  Which two tasks can be performed through an Informix Grid? (Choose two.)

  A. Install Informix products.

  B. Start Informix servers in a grid.

  C. Copy external files to grid servers.

  D. Setup replication automatically in a grid.

  E. Modify replication server attributes for grid servers.

  Correct Answer: CD

• Question 25:

  What are two requirements for the "ifxclone" utility? (Choose two.)

  A. All databases must use logging.

  B. The source server must be a secondary server.

  C. Only one server clone process can occur at a time.

  D. Both the source and target servers must be part of a trusted network environment.

  E. Both the source and target servers must use the same type of disk space (raw or cooked).

  Correct Answer: CD

• Question 26:

  Where must the HA_FOC_ORDER configuration parameter be set?

  A. Any server in the cluster.

  B. The primary server only.

  C. The SDS secondary only.

  D. The HDR secondary only.

  Correct Answer: B

• Question 27:

  Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

  A. DELAY_APPLY

  B. HDR_TXN_SCOPE

  C. LOG_INDEX_BUILDS

  D. FAILOVER_TX_TIMEOUT

  Correct Answer: B

• Question 28:

  Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to-end secure connection?

  A. On-disk encryption

  B. Enterprise Replication

  C. High-Availability Data Replication

  D. Server-to-server distributed query communication

  Correct Answer: A

• Question 29:

  In an organization, all employees are authenticated via domain wide Kerberos single sign-on. The DBSA wants to provide access to the database server for an employee without requesting the Operating System (OS) administrator to create a OS level user account. Which Informix feature does the DBSA need to leverage?

  A. Mapped users

  B. Role based users

  C. Table level access for users

  D. Label based access for users

  Correct Answer: A

• Question 30:

  Which statement is true regarding default roles?

  A. The DBSA can define a default role to assign only to the PUBLIC group for a particular database.

  B. The privileges associated with a default role takes precedence over the privileges granted to an individual user.

  C. The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.

  D. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

  Correct Answer: C