Tag: mainframe

Questions Related to mainframe

Multiple choice technology mainframe

Which step analyzes all the static SQL and stores the more efficient path to the data in a plan/package while compiling a cobol/DB2 program

Precompile
Package
Bind
Plan

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

COBOL host structures can have maximum of three levels in a COBOL/DB2 program

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Which assembler routine used to obtain a formatted form of the SQLCA and a text message based on the SQLCODE field of SQLCA

SQLCA
DCLGEN
DSNTIAR
SQLSTATE

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

To allow DB2 to close a cursor after a commit or a rollback operation, we use the WITH HOLD option of the DECLARE CURSOR statement.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

In the segemented table space each segment contain.

Can contain only one table but rows from different tables are mixed
Can contain only one table but rows from different tables are not mixed
Can contain more than one table but rows from different tables are mixed
None of these

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Which DB2 Utility is used to declare Tables in cobol/DB2 programs

DCLGEN
SQLCA
SQLSTATE
SQLCODE

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

The performance of static SQL is better than dynamic SQL, because for static SQL the binding is done only once and the program can be executed many times

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

The SQL statement EXECUTE IMMEDIATE causes an SQL statement to prepare and execute, dynamically, at run time.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

When using DISPLAY statement, on the system punch device, the last eight characters are used for

Line Number
PROGRAM-ID name
User ID
Nothing

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

ENTRY is

Entry will enter the main program and execute it.
Specifies the program entry.
It establishes an alternate entry point into a COBOL called subprogram.
ENTRY is not a COBOL keyword

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
35
36
37
38
39
40
41
42
43
…
299
300
Next →