← Back to exam page

C2090-619 – IBM Informix 12.10 System Administrator

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which two parameters are mandatory when running "ifxclone"? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Target server instance size.
  • ○

    Target server instance name.
  • ○

    Source server instance sqlhosts.
  • ○

    Target server configuration parameters.
  • ○

    Source server instance TCP/IP address.
Question 5

Which two statements are true? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Logical log files must always reside in rootdbs.
  • ○

    Having too little log space does not affect performance.
  • ○

    Having too much log space does not affect performance.
  • ○

    Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.
  • ○

    Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.
Question 6

The DBA has defined the following configuration parameters in the onconfig file:

C:\Pasban Work\Cert Paper Exams\IBM\000-619\000-619-Extracted\000-619-Extracted\ib619b\21.JPG

What are the actual values for LMM START THRESHOLD and LMM STOP THRESHOLD computed internally by the database server?

Select an option, then click Submit answer.

  • ○

    LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB
  • ○

    LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB
  • ○

    LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB
  • ○

    LMM START THRESHOLD = 2% and LMM STOP THRESHOLD = 3% of physical memory in the system