1. Home
  2. IBM
  3. C2090-619

IBM Informix 12.10 System Administrator

Exam Details

  • Exam Code
    :C2090-619
  • Exam Name
    :IBM Informix 12.10 System Administrator
  • Certification
    :IBM Certifications
  • Vendor
    :IBM
  • Total Questions
    :60 Q&As
  • Last Updated
    :Dec 10, 2024

IBM IBM Certifications C2090-619 Questions & Answers

  • Question 51:

    Which two statements are true about archecker utility? (Choose two.)

    A. Archecker can help developers team to debug procedures.

    B. Archecker can do backup testing, fully integrated with onbar and ontape utilities.

    C. Archecker can copy data from different servers, even restoring from a remote device.

    D. Archecker can use all kind of connections protocols, including shared memory connections.

    E. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.

  • Question 52:

    When the server is in administration mode, which users are NOT allowed to connect?

    A. informix

    B. Members of the DBSA group

    C. Members of the DBSSO group

    D. Users specified by ADMIN_MODE_USERS

  • Question 53:

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

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

    When using the deployment assistant, which two statements are true? (Choose two.)

    A. A java environment must be configured.

    B. The Informix user account must be used.

    C. Chunks can be raw devices or buffered files.

    D. The user must have connect permission to all databases.

    E. The user must have connect privilege to sysadmin database.

  • Question 56:

    When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

    A. LOW_MEMORY_SVR

    B. LOW_MEMORY_MGR

    C. LOW_MEMORY_RESERVE

    D. LOW_MEMORY_PRESERVE

  • Question 57:

    Which of the following is NOT possible during a non-root Informix Server installation?

    A. Role Separation

    B. Create users and groups

    C. Create a database server instance

    D. Secure the Informix installation directory

  • Question 58:

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

    Which communication protocol needs additional configuration besides onconfig and sqlhosts?

    A. TLITCP

    B. IPCSTR

    C. IPCSHM

    D. SOCSSL

  • Question 60:

    Which two DataBlade extensions can be automatically registered? (Choose two.)

    A. Web DataBlade

    B. Spatial DataBlade

    C. TimeSeries DataBlade

    D. Excalibur Text DataBlade

    E. High Performance Loader DataBlade

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 C2090-619 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.