Technology | Practice Questions | Aliensbrain

Multiple choice technology mainframe

How JCL steps can be skipped?

IF THEN/ELSE
COND
BOTH
Steps cannot be skipped in JCL.

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Possible ways to rectify S322, a. Change the CLASS b. TIME=1440 c. Remove abnormal logic in the code(like infinite looping). d. Change PRTY

a & b only
b & c only
a, b, c only
d only

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Possible causes for S0C4 a. Reading a file that is not open. b. Invalid address referred due to subscript error c. Tried moving variable length record that was larger than target field size.

a, b, & c
a only
a & b only
b only

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Maximum number of steps in a JCL

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Maximum number of TRKs can be allocated with below SPACE statement. SPACE=(TRK,(4,1),RLSE)

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

In Step1 gdgname(+1) has been created and step1 executed successfully. In Step 2 if same data set need to be used. How to refer it?

Gdgname(0)
Gdgname(+1)
Gdgname(-1)
Gdgname(+2)

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

2.JES2 allocate the space just before the step execution, JES3 allocate the space before job starts ( job came into Input Queue)

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

2.SD37, SB37, SE37 – All three indicates dataset out of space.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

create or replace function add_three_numbers (a number := 0, b number := 0, c number := 0) return number is Begin return a+b+c; End; / Which is not a valid procedure call in Oracle 10g

Begin Dbms_output.put_line(add_three_numbers (3,4,5)); End; /
Begin Dbms_output.put_line(add_three_numbers (a => 3, b=>4,c=>5)); End; /
Begin Dbms_output.put_line (add_three_numbers (3, b=>4,c=>5)); End; /
select add_three_numbers (3, b=>4,c=>5) from dual

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

To be callable from SQL expressions, a user-defined function must: 1. Be a stored function 2. Accept only IN parameters 3. Accept only valid SQL data types, not PL/SQL specific types, as parameters 4. Return data types that are valid SQL data types, not PL/SQL specific types

All are true
1, 2 and 4 are true
1 and 2 alone true
2 and 3 alone are ture

Reveal answer Fill a bubble to check yourself

Tag: technology

Questions Related to technology