← Back to exam page

C2090-558 – Informix 11.70 Fundamentals

Loading demo links...

Showing 4–6 of 10 questions

Question 4 (Volume A)

You have a database server environment where all databases use buffered logging. In which two conditions are the logical-log buffers in shared memory flushed to the logical log on disk? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    When the buffer is full.
  • ○

    When a checkpoint occurs.
  • ○

    When a user issues a begin work.
  • ○

    When a user commits the transaction.
  • ○

    When a user rolls back the transaction.
Question 5 (Volume B)

When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Columns that are used in indexes.
  • ○

    Columns that are used in constraints.
  • ○

    You provide no value for a specific column.
  • ○

    Where a zero is specified in the VALUES clause of a serial column.
  • ○

    Where you specify the NULL keyword in the VALUES clause for a specific column.
Question 6 (Volume A)

Which utility can be used to relocate the physical log to a new dbspace?

Select an option, then click Submit answer.

  • ○

    onlog
  • ○

    ontape
  • ○

    onspaces
  • ○

    onparams