1. Home
  2. IBM
  3. A2090-619

Assessment: Informix Server 12.10 Assessment

Exam Details

  • Exam Code
    :A2090-619
  • Exam Name
    :Assessment: Informix Server 12.10 Assessment
  • Certification
    :IBM Certified System Administrator
  • Vendor
    :IBM
  • Total Questions
    :130 Q&As
  • Last Updated
    :Mar 30, 2025

IBM IBM Certified System Administrator A2090-619 Questions & Answers

  • Question 1:

    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

  • Question 2:

    When KAIO is available and raw disk is used, which statement is true?

    A. Logical Log IO is performed by the LIO VP.

    B. Physical Log IO is performed by the PIO VP.

    C. Logical Log IO is performed by the KAIO VP.

    D. Physical Log IO is performed by the CPU VP.

  • Question 3:

    Which communication protocol needs additional configuration besides onconfig and sqlhosts?

    A. TLITCP

    B. IPCSTR

    C. IPCSHM

    D. SOCSSL

  • Question 4:

    Which log file CANNOT be rotated using the default "message log rotate" SQL admin command?

    A. audit log

    B. message log

    C. onbar debug log

    D. onbar activity log

  • Question 5:

    After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?

    A. sarah

    B. karin and dave

    C. karin and sarah

    D. karin, dave and sarah

  • Question 6:

    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

  • Question 7:

    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.

  • Question 8:

    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

  • 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.

  • Question 10:

    Click on the exhibit. Which type of join is occurring?

    A. Star Join

    B. ANSI Join

    C. Index Self-Join

    D. Multi Index Join

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your A2090-619 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.