If a=1 or 2 or 3 NEXT SENTENCE ELSE move a to b. a) if A not = 1 or 2 or 3 move A to B b) if not A = 1 and 2 and 3 move A to B c) if A Not = 1 and 2 and 3 move A to B d) if A NOT = 1 or NOT=2 or NOT =3 move A to B

Total no of bytes in the following 01 rec-1 02 first-group 03 a1 pic x(4). 03 a2 pic 99. 02 second-group redefines first-group. 03 A3 pic999. 03 A4 pic 999. 02 third-group. 03 A5 occurs 5 times pic 99. A)22 B)16 C)12 D)10

Determine the total no of bytes in the following 01 rec1 . 02 a pic x(6). 02 b redefines a. 03 c occurs 6 times pic 9. 02 d occurs 4 times. 03 e pic x(5). 03 f pic 999. a)38. b)44 c)14 d)32

subscripting can be said as A) subscripting enables us to write a move compact code in the procedure division. B) subscripting enables us to refer to any element of a table by the same data name with the facility of identifying a particular element through the values of subscript. C) Subscripting reduces the no of entries to be included in the data division D) subscripting enables us to use loops in the procedure division

01 A 02 B occurs 10 times 03 C pic 999. 03 D occurs 15 times 04 E pic 999. 04 F occurs 20 times 05 G pic XXX. 05 H pic 99. Determine the total no of byte in A. A) 175 B) 15480 C) 21750 D) 9065

which one of the following cannot cause more than one execution of paragraph that may be nam in statement. A) simple perform B) perform with time C) perform until D) perform varying

01 T1. 02 month-day pic x(30) value ?jan,31, feb,28, mar,31, apr,30, may,31, june, 30? 02 new-day redefines month-day occurs 6 times 03 A pic xxx. 03 B pic 99. What are the content of A(3) and B(2) respectively A)mar,31 B) Feb,28 C) 28, Mar E)Mar, 28

which of the following is not true about search verb A) every search stmt must contain the AT END clause B) any no of WHEN clause can be used with this verb C) this verb can only applied to a table which is defined with the OCCURS clause and INDEXED phases. D) WHEN condition is satisfied

which are the following verb can be used to manipulate the value of an index name A) ADD B) MOVE C) SUBTRACT D) SET

GO TO stmt which of the following is not true A) GO TO stmt is not essential in the sense that it is possible to write programs without using GO TO B) The target of the GO TO stmt being a procedure name avoiding GO TO result in a program with no procedure name C) Indiscriminate use of GO TO stmt can make the control structure program substantially complex D) Too many GO TO stmts make a program difficult to understand

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

characters of DBMS A) non redundant B) data independence C) increased security D) all the above

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures