IBM IBM Certifications C2090-619 Questions & Answers

• Question 41:

  Click on the exhibit. Which type of join is occurring?

  A. Star Join

  B. ANSI Join

  C. Index Self-Join D. Multi Index Join

  Correct Answer: A

• Question 42:

  What is the purpose of the ifx_getMartStat() function?

  A. To display status information about the data mart.

  B. To display update statistics information about the data mart and its tables.

  C. To display statistics about the workers and coordinators defined for the accelerator.

  D. To display status information about the Informix Warehouse Accelerator and all the data marts.

  Correct Answer: A

• Question 43:

  Which two statements are true about Informix OpenAdmin Tool? (Choose two.)

  A. Informix OpenAdmin Tool does not support multiple languages.

  B. Ontape backup can be taken using Informix OpenAdmin Tool.

  C. Informix cluster cannot be managed using Informix OpenAdmin Tool.

  D. Informix OpenAdmin Tool cannot be used to run the equivalent of onstat commands.

  E. SQL explorer feature provides Query Drill Down functionality to analyze SQL statements.

  Correct Answer: BE

• Question 44:

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

  

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

  A. LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB

  B. LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB

  C. LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB

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

  Correct Answer: B

• Question 45:

  "informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear", "informix_stores");

  A. Shuts down the primary server and converts the secondary server to be the primary.

  B. Clears the log position of the SDS servers and restarts replication.

  C. Converts the shared disk secondary server to a standard server and shuts down the primary server.

  D. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

  Correct Answer: D

• Question 46:

  What command unlocks the storage catalogs when using the Primary Storage Manager?

  A. onbar -d unlock

  B. onpsm -C unlock

  C. onmode -C unlock

  D. onsmsync -c unlock

  Correct Answer: B

• Question 47:

  Where are the Primary Storage Manager catalog tables stored?

  A. sysutils database

  B. sysadmin database

  C. sysmaster database

  D. A location as specified by the PSM_CATALOG_PATH configuration parameter

  Correct Answer: D

• Question 48:

  Which storage manager allows specification of a larger size than others for BAR_XFER_BUF_SIZE?

  A. Informix Storage Manager (ISM)

  B. Informix Primary Storage Manager (PSM)

  C. Informix Secondary Storage Manager (ISSM)

  D. Informix Archive Restore Storage Environment (IARSE)

  Correct Answer: B

• Question 49:

  Which statement is true about log salvaging?

  A. ontape cannot perform salvage of logs.

  B. Log salvaging cannot be avoided if onbar is used for restore.

  C. Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.

  D. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.

  Correct Answer: D

• Question 50:

  When you take a level 2 backup, what data is backed up?

  A. All new data since the last level 1 backup.

  B. All new data since the last level 2 backup.

  C. All logical logs which have not previously been backed up.

  D. All new data since the last level 0, level 1 or level 2 backup.

  Correct Answer: A