Question 1.
Which choice is a valid stereotype for a record?

A. Array
B. CSV
C. ExternalType
D. Form

Answer: A

Question 2.
ProgramAcalls ProgramB. Both programs access a relational database. 

What is the primary difference between the EGL system variables sqlLib.sqlData and sysVar.sqlData?

A. sqlLib.sqlData and sysVar.sqlData are interchangeable and always have the same values.
B. sqlLib.sqlData contains all the available information from the SQLCA; sysVar.sqlData only 
    contains the SQLCODE.
C. The scope ofsysVar.sqlData is local to each program; the scope of sqlLib.sqlData is global so 
    that both ProgramA and ProgramB can access the results of the most recent SQL I/O 
    statement regardless of which program the I/O occurred in.
D. There is no system variable namedsqlLib.sqlData.

Answer: B

Question 3.
Which statement demonstrates how to call a DB2 Stored Procedure passing three parameters and returning a result set?

A. callstoredProcedureName (parm1, parm2, parm3);
B. execute #sql {call storedProcedureName(parm1, parm2, parm3)};
C. openresultSetID with #sql {call storedProcedureName (:parm1, :parm2, :parm3)};
D. The current implementation for EGL only supports calling DB2 Stored Procedures for 
    Insert/Update/Delete.

Answer: B

Question 4.
Which EGL statement demonstrates the correct way to initialize a dynamic array of integers so that the first element has the value 3?

A. myArray INT =3;
B. myArray INT[] =3;
C. myArray INT[3];
D. myArray INT[3] =3;

Answer: C

Question 5.
Which EGL move statement is valid?

A. move RECORDA to RECORDBbyByte;
B. move RECORDA to RECORDBbyPosition;
C. move RECORDA to RECORDB withVAGenCompat;
D. move RECORDA to RECORDB for INDEX1 to INDEX2;

Answer: A

Question 6.
What is the BEST technique to retrieve SQL data in the situation where there might be hundreds of rows that satisfy the criteria for the WHERE clause?

A. An open statement with themultipleRows option
B. An open statement followed by a loop of get next statements to retrieve all the rows
C. A get statement with implicit SQL to retrieve all the rows into a dynamic array
D. A get statement with a customized SQL WHERE clause and set boundaries for the retrieve 
    using the SQL BETWEEN predicate

Answer: C

Question 7.
Which choice is ONLY supported in generated COBOL programs?

A. DL/I access
B. Text forms
C. BIRT reports
D. eliminatesystemdependentcode build descriptor option

Question 8.
Which statement is true about the linkage options part?

A. ThecallLink element provides details on how a call statement is to be implemented when 
    calling a particular program, but has no effect on generation for the called program.
B. ThefileLink element provides details on whether to use remote MQ queues.
C. ThetransferToProgram element provides details on how a transfer to program statement is to  
    be implemented when transferring control to a particular program.
D. ThetransferToTransaction element provides details on how a transfer to transaction statement 
    is to be implemented when transferring control to a particular transaction in transactional 
    environments such as CICS, but has no effect on generation of programs for nontransactional 
    environments.

Answer: B

Question 9.
An EGL application running in a stateless environment (Web, CICS, or IMS) has presented data to the user for update. What is the BEST way to update an SQL row containing many columns if there is a chance that some other user could change the data?

A. Reread the row before the update and ensure all columns are the same as before the data 
    was presented to the user
B. Reread the row andcompare some column that is known to be changed on every update (a 
    timestamp, for example)
C. Lock the row across the userthink time so no one else can change it
D. Just update the row as quickly as possible

Answer: A

Question 10.
Which method is used to create and update code templates?

A. click the Windows > Preferences > EGL menu
B. pressCtrl+T to bring up a template editor during an EGL edit session
C. right-click within an EGLedit session and then click the Create Template option
D. add the Template view to any perspective and then use the menus to create or update code 
    templates for this view

	Web www.certsbraindumps.com