DB2-CICS

Length of the trans id is

• 4

• 5

• 8

• 6

Transid which is used to manage transactions , files, db2 entry

• CEDA

• CEMT

• CESF

• CEDF

Macro which is used to define fields in BMS?

• DFHMSD

• DFHMDI

• DFHMDF

• EIBAID

CICS command used to where no action needs to be taken during an exception?

• Handle Condition

• Ignore Condition

• RESP code

• Handle ABEND

How does CICS validate keys pressed by user

• EIBCALEN

• EIBAID

• EIBKEYS

• None of the above

Process used in DB2 to check the validity of the user?

• Compile

• Bind

• Access

• Authorisation

Number of rows in Relational term?

• Cardinality

• Attributes

• Tuple

• Degree

Referential integrity is done in tables by using

• Primary key

• Alternate key

• Foreign key

• None of the above

SmallInt in DB2 data type occupies

• 4 byte

• 2 byte

• 8 byte

• 1 byte

SPUFI abbreviation

• Sql Programming using Files

• SQL Processing using file input

• SQL processing using Files

• SQL processing using File Interaction