C2090-558

C2090-558 practice questions, page 4 of 5, with answer review and explanations.

Question 16

Which two of the following are required for creating a dbspace? (Choose two.)

  1. a mirror chunk
  2. two or more chunks
  3. a cooked file or raw device
  4. a file owned by root or administrator
  5. dbspace name containing only letters, digits, underscores, or $ characters.

Question 17

Which two operations are performed with the onspaces command? (Choose two.)

  1. Add space to the server.
  2. Compress server space.
  3. Encrypt the server space.
  4. Remove space from the server.
  5. Restrict access to the server space.

Question 18

Given INFORMIXCONTIME = 60 and INFORMIXCONRETRY = 3, if the initial connection attempt fails, what subsequent attempts will be made to connect?

  1. 60 and 120 seconds before aborting
  2. Every 3 minutes within one hour before aborting
  3. Every 3 seconds within one hour before aborting
  4. Wait indefinitely until it is successfully completed

Question 19

A progammer wants to unload a table to a file inside a stored procedure. What functionality listed below will help the programmer accomplish the task?

  1. dbload
  2. dbexport
  3. external table
  4. SQL unload statement

Question 20

Which Informix data movement utilities listed below can be used to move database from a computer running Windows operating system to an Apple computer?

  1. ontape
  2. onunload and onload
  3. ifxsend and ifxreceive
  4. dbexport and dbimport