IBM C2060-350 Online Practice Questions and Exam Preparation

IBM C2060-350 Online Questions & Answers

• Question 51:

  The following map rule returns the incorrect results; however, the map rule does return the expected results when each LOOKUP is run independently. =IF(PRESENT(Name:.:AddressFile), LOOKUP(Record:input,Field1 Field:Record:input="aa"), LOOKUP(Record:input,Field1 Field:Record:input="cc")) Why does the rule return the INCORRECT results?

  A. Both LOOKUPs reference the same series object.
  B. Two LOOKUPs are not allowed in a single map rule.
  C. IF(PRESENT) was used instead of WHEN(PRESENT).
  D. The syntax of the object name Name:.:AddressFile is incorrect.
  A. Both LOOKUPs reference the same series object.

• Question 52:

  Refer to the image shown here: Which map rule function takes the MOST time to run?

  

  A. LOOKUP
  B. MAP_NAME
  C. TYPE_NAME
  D. BUILD_CARD
  A. LOOKUP

• Question 53:

  Which of the following statements about the RUN function is TRUE?

  A. All maps executed via the RUN function must be in the same map source file.
  B. The RUN function can be used to dynamically name source and/or destination files.
  C. The first argument of the RUN function can be the name of a functional or executable map.
  D. All compiled maps executed via the RUN function must be in the same directory as the calling map.
  B. The RUN function can be used to dynamically name source and/or destination files.

• Question 54:

  Refer to the image shown here:

  

  Output card #2 creates a summary report that provides run time statistics. The Amount field in output card #2 is the total amount of all orders in the NewSysFile. Output card #2 creates a summary report that provides run time statistics. The Amount field in output card #2 is the total amount of all orders in the NewSysFile. Output card #2 creates a summary report that provides run time statistics. The Amount field in output card #2 is the total amount of all orders in the NewSysFile.

  Which of the following is the MOST EFFECIENT map rule for the Amount field in output card #2?

  A. =TotalAmount Field:NewSysFileA.=TotalAmount Field:NewSysFile
  B. =SUM(TotalAmount Field:NewSysFile)B.=SUM(TotalAmount Field:NewSysFile)
  C. =ADD(ExtendedPrice Field:.:NewSysFile)C.=ADD(ExtendedPrice Field:.:NewSysFile) D.
  D. =ExtendedPriceField:.:NewSysFile * No_of_Records Field:NewSysFileD.=ExtendedPriceField:.:NewSysFile * No_of_Records Field:NewSysFile
  A. =TotalAmount Field:NewSysFileA.=TotalAmount Field:NewSysFile

• Question 55:

  What is the difference between the INT function and the ROUND function? The INT function always discards the decimal, and the ROUND function:

  A. rounds up and then always discards the decimal.
  B. rounds up or down and then always discards decimal places.
  C. rounds up or down to the number of decimal places specified.
  D. discards unwanted decimal places and then rounds up or down.
  C. rounds up or down to the number of decimal places specified.

• Question 56:

  One way to modify a type tree to increase performance is to:

  A. map the unused elements that are not used to =NONE.
  B. change the numeric type elements to alphanumeric type elements.
  C. move the unused elements into a reserved category called 'NonUsed'.
  D. combine any contiguous elements that will not be mapped into a large blob.
  D. combine any contiguous elements that will not be mapped into a large blob.

• Question 57:

  Refer to the image shown here:

  

  A large corporation manufactures beds in different colors. The inventory file consists of three record types, a header, a detail, and bed color. The record type is the first byte of each record (H=Header, D=Detail, C=Color). If there is an error in one of the bed color records, all of the color records under that detail record should be ignored. How can an application developer specify that all color records should be ignored if one is found to be invalid?

  A. Use the restart function in the map.
  B. Use the restart attribute on the color record.
  C. Use the restart attribute on the detail record.
  D. Use the restart attribute on the header record.
  C. Use the restart attribute on the detail record.

• Question 58:

  A database table is depicted here:

  

  Which of the following functions COULD be used to return only the text string that is found in the Part_Description column of the database?

  A. Either DBLOOKUP or DBQUERY
  B. DBQUERY
  C. DDEQUERY
  D. DBLOOKUP
  A. Either DBLOOKUP or DBQUERY

• Question 59:

  What additional parameter is needed when using a database for an input, that is not used when using a database for output?

  A. Query
  B. Password
  C. mdq file name
  D. Database Name
  A. Query

• Question 60:

  A map has been designed to append to an audit log when a validation error occurs. The map is being run using the Command Server. At runtime, the map intermittently fails. After some investigation, it is determined that the same map is being called by a RUN function in another map. Which of the following options MAY reduce the number of map failures?

  A. Enable a Map Retry.
  B. Enable a Card Retry on the input cards.
  C. Change the Map Audit Action setting from "Append" to "Create".
  D. Modify the map settings to specify a custom file name for the audit log.
  A. Enable a Map Retry.