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
2 8486Total 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
3 8301Determine 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
3 9553subscripting 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
1 571201 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
3 9880which 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
3 691601 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
1 7281which 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
2 12609which are the following verb can be used to manipulate the value of an index name A) ADD B) MOVE C) SUBTRACT D) SET
4 17688GO 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
2 6963DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
4 9401AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
2 20029how 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
2 10494what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
5 15617which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
3 10019
What is sqlca?
How to find the maximum value in a column in the db2 database?
What do you mean by CEMT?
Whenever a cics program goes through a compilation process, there is always some extra code that is added to the program. Where exactly does this new piece of code go to and what is it termed as ?
What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?
Explain the use of the where?
How to execute a query in qmf at a particular time?
How to take backup of table in db2?
Ap wkur,=p5 where wkur is a label?
How can a jobs execution priority be modified?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What are the uses of ppt in cics?
What is a db2 table?
Can you explain differences between temporary storage queue (tsq) and transient data queue (tdq)?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.