Study with C9050-042 most valid questions & verified answers

Which code should NOT be split out into separate subroutines?

• A. Redundant code in a group otprograms.
• B. Redundant code in a program.
• C. Dead code in a program.
• D. Code which must be available on different platforms.

Requirement:
If the value of the numeric variable I is 1 it needs to be changed to 2 and vice versa. In all other cases it
must remain unchanged. Which of the following solutions meets the requirement and does not require
essential structural modifications when the requirement is changed to the following: If the value of the
numeric variable I is 512 it needs to be changed to 731 and if the value is 814 it needs to be changed to 5.
In all other cases it must be set to 111.

• A. IF I = 1 THEN I = 2;
  IF I = 2 THEN I = 1;
• B. SELECT (I);
  WHEN(1) I = 2;
  WHEN(2) I = 1;
  OTHER;
  END;
• C. DCL ONETWO(2) BIN FIXED(15) INIT(2,1);
  IF I = 1! I = 2
  THEN I = ONETWO(I);
• D. lF I = 1 ! 1 = 2
  THEN I = 3 - I;

A programmer has submitted the following declaration for review. What feedback should be provided to
the programmer?
DCL 1 A,
2 B DIM (1000) FIXED BIN (31) INIT (0),
2 C DIM (1000) FIXED BIN(15) INIT (0);

• A. A is incorrectly initialized and the code must be changed.
• B. The code is good as written.
• C. Discuss with the programmer how many elements of the arrays need to be initialized.
• D. The declaration of A should be changed because the current declaration contains padding bytes.

The lead developer on a project has just learned that Pat, a highly skilled programmer on the team, has
been reassigned. The lead developer is familiar with Pat's work and is concerned because no one on the
team has the necessary skills to pick up the work immediately. A new employee with the required skills is
joining the team next week, but the timeline for a mission critical milestone has been moved up to the end
of this week. Which of the following is the most appropriate action for the lead developer to take to ensure
that the critical milestone is met?

• A. Explain to the team why this change in schedule is important to the customer.
• B. Explore with the team whether they will be able to meet the new deadline.
• C. Direct the team to cover all of Pat's work until the new employee arrives.
• D. Personally cover the work until the new employee arrives.

Given the following code:
DCL INDATA FILE RECORD INPUT;
DCL INSTRUC CHAR(100);
DCL EOF BIT(1) INIT('0'B);
ON ENDFILE(INDATA) EOF = '1'B;
OPEN FILE(INDATA);
READ FILE(INDATA) INTO(INSTRUC);
DO WHILE (^EOF);
CALL SR_PROCESS;
READ FILE(INDATA) INTO(INSTRUC);
END;
CLOSE FILE(INDATA);
If the database (input file) changes from OS-PS to DB2 view and the necessary syntax has been changed
accordingly, which of the following DB2-related steps is NOT additionally required to guarantee the same
level of stability and functionality?

• A. Set the EOF bit to '1'B, if SQLCODE = 100 (not found).
• B. Check the SQLCODE after each EXEC SQL OPEN / CLOSE statement.
• C. Check the SQLCODE after each EXEC SQL FETCH statement.
• D. Check the CURRENT SQLI