← Back to exam page

C2090-619 – IBM Informix 12.10 System Administrator

Loading demo links...

Showing 7–9 of 10 questions

Question 7

Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to-end secure connection?

Select an option, then click Submit answer.

  • ○

    On-disk encryption
  • ○

    Enterprise Replication
  • ○

    High-Availability Data Replication
  • ○

    Server-to-server distributed query communication
Question 8

Given these statements are executed:

C:\Pasban Work\Cert Paper Exams\IBM\000-619\000-619-Extracted\000-619-Extracted\ib619a\42.JPG

which statement is true?

Select an option, then click Submit answer.

  • ○

    The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.
  • ○

    The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator (IWA).
  • ○

    The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and
    OLAP expressions are evaluated by Informix database server.
  • ○

    The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAP expressions are evaluated by Informix Warehouse Accelerator (IWA).
Question 9

Which option maximizes performance in an Informix Warehouse (DSS) environment?

Select an option, then click Submit answer.

  • ○

    Higher value of LOGBUFF.
  • ○

    Higher value of PHYSBUFF.
  • ○

    Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.
  • ○

    SHMTOTAL set to 0 to allow Informix to access all available physical memory.