Sawaal
  • Home/
  • Searching for he

 Searching for "he"

Q:

In a DB2-CICS program which acts as co-ordinator and which is the participant?

Answer

DB2 acts as the participant and CICS acts as a co-ordinator


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

In terms of DB2 indexing, what is the root page?

Answer

The simplest DB2 index is the B-tree and the B-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search. 


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

When does the SQL statement gets executed when you use cursor in the application programming?

Answer

SQL statement gets executed when we open cursor


 

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is the self-referencing constraint?

Answer

A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is the difference between primary key & unique index ?

Answer

Primary key : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.


Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What is the need to code COMMITS in batch programs?

Answer

COMMIT statements are used to release locks which are required for that unit of work, and then permit a new unit of work. In other words, if COMMITS are not coded in the program and the program has been sent for execution, then while processing, in place of just going back to a few inserts since the nearest commit, the program has to go back to the inserts which were made during the entire run of the program. This extra process takes around twice or thrice the time taken normally.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

Name and explain the type of locks?

Answer

There are three types of lock, namely:


Shared – This type of lock permits two or more programs to read from the locked space but does not allow them to change it.


Update – This lock is more lenient. It permits the program to read and change the locked space.


Exclusive – This lock restricts all users from accessing the locked space.

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview

Q:

What does it mean if the null indicator has -1, 0, -2?

Answer

 -1 indicates the field is null


 0 indicates the field is not null


 -2 indicates the field is truncated

Report Error

View answer Workspace Report Error Discuss

Subject: Mainframe Interview