IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 1:

  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
  A. Mapped users

• Question 2:

  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.
  D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

• Question 3:

  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
  D. Onconfig file, user local shell, system global

• Question 4:

  Where are the Primary Storage Manager catalog tables stored?

  A. sysutils database
  B. sysadmin database
  C. sysmaster database
  D. A location as specified by the PSM_CATALOG_PATH configuration parameter
  D. A location as specified by the PSM_CATALOG_PATH configuration parameter

• Question 5:

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

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

• Question 6:

  Which action can be taken if an instance is down?

  A. A point-in-time mixed restore.
  B. Warm restore of non-critical storage spaces.
  C. Cold restore by onbar using storage space backups taken by ontape on tape devices.
  D. A mixed restore using onbar whole system backup and incremental dbspace level backups.
  A. A point-in-time mixed restore.

• Question 7:

  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.
  B. The primary server only.

• Question 8:

  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.
  D. The SELECT query will return results from store3 and store4.

• Question 9:

  Which two statements are true about Enterprise Replication of TimeSeries data types? (Choose two.)

  A. ATS and RIS files must be in XML format.
  B. The replicate must be a mastered replicate.
  C. The conflict resolution rule must be always-apply.
  D. The WHERE clause in the participant definition must include a TimeSeries column.
  E. CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server.
  B. The replicate must be a mastered replicate.
  C. The conflict resolution rule must be always-apply.

• Question 10:

  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.
  C. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.