IBM IBM Certifications C2090-558 Questions & Answers

• Question 101:

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

  A. ontape

  B. onunload and onload

  C. ifxsend and ifxreceive

  D. dbexport and dbimport

  Correct Answer: D

• Question 102:

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

  A. 60 and 120 seconds before aborting

  B. Every 3 minutes within one hour before aborting

  C. Every 3 seconds within one hour before aborting

  D. Wait indefinitely until it is successfully completed

  Correct Answer: A

• Question 103:

  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?

  A. dbload

  B. dbexport

  C. external table

  D. SQL unload statement

  Correct Answer: C

• Question 104:

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

  A. Add space to the server.

  B. Compress server space.

  C. Encrypt the server space.

  D. Remove space from the server.

  E. Restrict access to the server space.

  Correct Answer: AD

• Question 105:

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

  A. onlog

  B. ontape

  C. onspaces

  D. onparams

  Correct Answer: D

• Question 106:

  What are two system level databases? (Choose two.)

  A. sysperf

  B. sysadmin

  C. sysmaster

  D. sysmonitor

  E. sysscheduler

  Correct Answer: BC

• Question 107:

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

  A. a mirror chunk

  B. two or more chunks

  C. a cooked file or raw device

  D. a file owned by root or administrator

  E. dbspace name containing only letters, digits, underscores, or $ characters.

  Correct Answer: CE

• Question 108:

  How can you determine which databases are created in an instance?

  A. use dbschema utility

  B. inspect ONCONFIG file

  C. List reserved pages with oncheck -pr

  D. run SELECT name FROM sysmaster:sysdatabases

  Correct Answer: D

• Question 109:

  You want to use sqlhosts file /newlocation/newsqlhosts. Which of the following is true?

  A. sqlhosts file must be called sqlhosts

  B. set INFORMIXSQLHOSTS variable to /newlocation/sqlhosts

  C. set INFORMIXSQLHOSTS variable to /newlocation/newsqlhosts

  D. sqlhosts file must be defined under $INFORMIXDIR/etc/ directory

  Correct Answer: C

• Question 110:

  Which of the following is true about system catalog tables access?

  A. Only user informix can read system catalog tables

  B. Only system administrators can read system catalog tables

  C. Only database administrators can read system catalog tables

  D. Any user that can connect to the database can read system catalog tables

  Correct Answer: D