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 101:

    What is the earliest version you can migrate / upgrade directly to Informix 12.10?

    A. 7.30

    B. 8.0

    C. 9.40

    D. 10.0

  • Question 102:

    The sector option for cdr utility is used to perform what operation?

    A. Dynamically convert ER cluster instances in order to perform rolling upgrades.

    B. Dynamically convert H/A cluster instances in order to perform rolling upgrades.

    C. Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform rolling upgrades.

    D. Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.

  • Question 103:

    To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?

    A. Shrink

    B. Repack

    C. Compress

    D. Defragment

  • Question 104:

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

    A. AAO

    B. DBSA

    C. DBSSO

    D. DBSECADM

  • Question 105:

    Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

    A. CKPTINTVL

    B. RA_PAGES

    C. CLEANERS

    D. SHMVIRTSIZE

  • Question 106:

    Which statement is valid about Data consolidation using send-only replicates?

    A. You can have more than one target server.

    B. You cannot modify a server to change its mode to send-only.

    C. You cannot use this replicate for tables that include TimeSeries columns.

    D. You need to define a different replicate for each send-only primary server.

  • Question 107:

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

    A. Login mode

    B. Client mode

    C. Server mode

    D. Password mode

  • Question 108:

    When you take a level 2 backup, what data is backed up?

    A. All new data since the last level 1 backup.

    B. All new data since the last level 2 backup.

    C. All logical logs which have not previously been backed up.

    D. All new data since the last level 0, level 1 or level 2 backup.

  • Question 109:

    Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)

    A. Byte

    B. Shared

    C. Update

    D. Exclusive

    E. Promotable

  • Question 110:

    Which statement is FALSE about Informix Automatic checkpoint Feature?

    A. Automatic checkpoints cause less logical log activity.

    B. Automatic checkpoints try to avoid transaction blocking.

    C. Automatic checkpoints cause the database server to trigger more frequent checkpoints.

    D. Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm or onmode -wf.

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.