IBM IBM Certifications C2090-558 Questions & Answers

• Question 21:

  What does the dbschema -ss option explicitly show besides lock mode, fragmentation strategy, and dbspace name?

  A. pagesize

  B. extent size

  C. creation date

  D. partition partnum

  Correct Answer: B

• Question 22:

  Which of the following can be used to move the physical log?

  A. onlog

  B. ondblog

  C. onspaces

  D. onparams

  Correct Answer: D

• Question 23:

  Which statement is true when using onload/onunload?

  A. The output will be in text format.

  B. The source and target operating system can be different.

  C. The target schema can be modified with additional columns.

  D. The source and target database Informix versions must be identical.

  Correct Answer: D

• Question 24:

  Which two statements about oninit are correct? (Choose two.)

  A. oninit can be used to initialize an Informix instance.

  B. oninit -m starts an Informix instance in multi-user mode.

  C. oninit -j starts an Informix instance in administration mode.

  D. oninit has a functionally equivalent Administration API command string.

  E. oninit can be used to change an instance from quiescent mode to online mode.

  Correct Answer: AC

• Question 25:

  Which command listed below can be used to change the state of an operating Informix server?

  A. oninit

  B. onstat

  C. onmode

  D. onparam

  Correct Answer: C

• Question 26:

  Which of the following methods can be used to tranfer data in EXPRESS mode?

  A. dbload

  B. external tables

  C. onload/onunload

  D. dbexport/dbimport

  Correct Answer: B

• Question 27:

  Which two SQL API commands can be used to create a 10 MB dbspace? (Choose two.)

  A. task ( )

  B. admin ( )

  C. oncmd ( )

  D. ifxcreate ( )

  E. oncreate ( )

  Correct Answer: AB

• Question 28:

  Which two tasks can be accomplished using the OpenAdmin Tool (OAT)? (Choose two.)

  A. Manage Virtual Processors (VP).

  B. Automate the update statistics process.

  C. Perform installation of an Informix server.

  D. Run the High Performance Loader (HPL) GUI tool.

  E. Remove an instance's orphaned shared memory segment.

  Correct Answer: AB

• Question 29:

  Click the Exhibit button.

  

  In the exhibit, which two statements are correct? (Choose two.)

  A. the rootdbs dbspace is online

  B. the dataspace dbspace is online

  C. the rootdbs dbspace contains 2 chunks

  D. the dataspace dbspace contains 2 chunks

  E. the dataspace and rootdbs are both online

  Correct Answer: AC

• Question 30:

  A DBA wants to know which commands have been executed through the SQL Admin API. What is the correct action?

  A. Use the built-in tasks in the sysadmin database.

  B. Query the ph_run table in the sysadmin database.

  C. Query the ph_task table in the sysadmin database.

  D. Query the command_history table in the sysadmin database.

  Correct Answer: D