1. Categories >> Software >> MainFrame
  2. Suggest New Category


MainFrame Interview Questions
Questions Answers Views Company eMail

What is auditing?

 2 4118

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

 2 4231

When do you specify the isolation level? How?

 1 4294

What do the initials DDL and DML stand for and what is their meaning?

 2 4410

What is the error code -803 ?

 3 10503

What can the SET option of the Repair Utility accomplish?

 1 4769

What are the levels of isolation available with DB2V4

IBM,

2 3733

Where are plans stored?

 2 6179

What is a clustering index?

 2 4504

What is a Resource Control Table(RCT)? Describe its characteristics.

 3 12053

How is the SUBSTR keyword used in sql?

 1 8541

What is an inner join, and an outer join ?

CTA,

1 12125

Where is the access path logic created by the DB2 Optimizer stored?

 1 7622

What is a root page?

 1 3672

What happens to the PLAN if index used by it is dropped?

 1 4973

Un-Answered Questions { MainFrame }

How joinkeys helps in sort?

563

what does check opcode do ?

1069

Mainframes gets a text file that contains the name of the file. Now using JCL i want to locate that file name in the mainframe system and perform further processing. Please tell how to proceed

1974

What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?

9222

How many bytes will a s9(8) comp field occupy ?

679




What do you mean by cursor?

586

what are all the contents of subfile?

995

Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?

662

What is the function of dd disp parameter?

658

how you will know whether you are in sfldrop or sflfold mode?

631

what is the difference between a return with transid and xctl? For example program. A is issuing return with transid to program b. Program a. Is isssuing xctl to program b?

679

What is distributed relational database architecture? And components?

555

How to create backup table in db2?

644

Which is the difference between delimited by size and delimited by space?

598

How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.

5064

For More Un-Answered { MainFrame } Questions Click Here