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

    Which operation can benefit from PDQ?

    A. Checkpoints

    B. Data replication

    C. DML Statement

    D. Login Log flushing

  • Question 2:

    Which command line utility does NOT have the equivalent functionality using the SQL Administration API?

    A. oninit

    B. onmode

    C. onspaces

    D. onparams

  • Question 3:

    How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

    A. Use the 'Committed Read' isolation level.

    B. Use the RETAIN UPDATE LOCKS clause with isolation level.

    C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.

    D. Use the SET TRANSACTION command to with SERIALIZABLE clause.

  • Question 4:

    Which Informix utility can be used to customize the onconfig file?

    A. ifxdeploy

    B. genoncfg

    C. dbaccess

    D. onparams

  • Question 5:

    You are running an UPDATE statement on a table using dbaccess. What kind of lock type is expected?

    A. Byte

    B. Update

    C. Shared

    D. Exclusive

  • Question 6:

    You have started a violations table for a target table with a non default name. (For example:

    "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;"). How can you determine the relationship between the violations table and the target table later?

    A. Using dbschema utility

    B. Using 'oncheck -pT' command

    C. Querying sysdepends system catalog table

    D. Querying sysviolations system catalog table

  • Question 7:

    The 'onstat -k' output is showing '56 lock table overflows'. Which catalog table can be used to display the relevant lock statistics?

    A. syslocks

    B. systables

    C. sysprofile

    D. sysoverflow

  • Question 8:

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

    What is the purpose of the GRANT ADMIN privilege?

    A. Grants the admin privilege to create role separation.

    B. Grants the admin privilege to perform DBSA functions.

    C. Grants the admin privilege to use the Open Admin Tool.

    D. Grants the admin privilege to run SQL administration API commands.

  • Question 10:

    Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

    A. DBUPSPACE

    B. DS_POOLSIZE

    C. VP_MEMORY_CACHE_KB

    D. DS_NONPDQ_QUERY_MEM

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.