最新なIBM 000-268問題集（92題）、真実試験の問題を全部にカバー！

質問 1：
Which of the following represents the sequence of embedded SQL statements required to extract multiple records based on criteria that are not known at compile time?
A. DECLARE cursor, EXECUTE statement, OPEN cursor, FETCH row(s), CLOSE cursor
B. PREPARE statement, EXECUTE statement, SELECT row(s), FETCH row(s), DROP table
C. PREPARE statement, DECLARE cursor, OPEN cursor, FETCH row(s), CLOSE cursor
D. DECLARE cursor, OPEN cursor, SELECT row(s), FETCH row(s), CLOSE cursor
正解：C

質問 2：
A program is created from two *MODULE objects: MYMODA and MYMODB. What type of call is being performed when a procedure in MYMODA calls a procedure in MYMODB?
A. Bound call by reference
B. Bound call by copy
C. Dynamic call by reference
D. Dynamic call by copy
正解：B

質問 3：
Given the following code segment:
D TaxCalc PR EXTPGM('MYPGM')
D Parm1 5p 0 CONST
D Parm2 10A OPTIONS(*NOPASS)
What is the purpose of the keyword OPTIONS(*NOPASS)?
A. The parameter will accept the special value *OMIT
B. If the parameter's value is changed by MYPGM, the caller will not see the new value.
C. The parameter is optional
D. The parameter cannot be modified by the called program
正解：C

質問 4：
Given the following code segment (Note that the field "Hours" is assumed to be defined in a database used by the program):
DName+++++++++++ETDsFrom+++To/L+++IDc.Keywords++++++++++++++++++++++++
+
D MonHrs DS D AverageHrs 4 2
D Employees 2 0
D TotalHours 7 2
C Eval Employees += 1
C Eval TotalHours = TotalHours + Hours
C Eval AverageHrs = TotalHours / Employees
An error occurs when executing this code. Which of the following would correct the error?
A. Add half-adjust to the third Eval statement
B. Increase the size of the AverageHrs field
C. Initialize the AverageHrs field to zero
D. Code the Inz keyword for the DS
正解：D

質問 5：
A program uses a display file with the record format SCR01 to retrieve the customer name for a supplied customer number. A user starts the program and does the following: 1. Sets the screen value of SCCUS# to 125 and presses the enter key. 2. Changes the screen value of SCCUS# to 153 and presses the F3 key. Given the following display file definiton segment:
A R SCR01
A CA03(03)
A SCCUS# 5 0B 11 15
A SCNAME 30 O 11 21
After F3 was pressed, what is the value of SCCUS#?
A. 153
B. 0
C. 125
D. *null
正解：C

質問 6：
Given the following code segment:
DName+++++++++++ETDsFrom+++To/L+++IDc.Keywords+++++++++++++++++++
D Arra s 3s 0 DIM(10)
D Index s 2s 0 Inz(0)
/FREE
For Index = 1 to %Elem(Arra);
Arra(Index) = 2 * Index;
EndFor; /END-FREE
What is the value of field Index after the code is run?
A. 0
B. 22
C. 11
D. 10
正解：C

質問 7：
A legacy application database file contains a pair of zoned, six digit fields called ORDDAT and DUEDAT, which contain the date in MMDDYY format. Which of the following expressions would update the DUEDAT field with a value representing 30 days after the date in ORDDAT.
A. duedat = %dec(%date(orddat:*mdy) + %days(30): *mdy);
B. duedat = %dec(%date(orddat:*mdy) + %days(30));
C. duedat = %int((%date(orddat:mdy) + %days(30)): *mdy);
D. duedat = %date(orddat:*mdy) + %days(30);
正解：A