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


IBM MainFrame Interview Questions
Questions Answers Views Company eMail

Name the different types of Table spaces.

IBM,

5 13532

How do you retrieve the data from a nullable column?

 2 7572

What is a clustering index ?

 3 6035

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

 1 6039

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

 2 8069

What else is there in the PLAN apart from the access path?

 1 4514

What is a host variable?

 3 5641

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

 1 9510

Once you create a view, where would information about the view be stored?

 1 4372

What information is used as input to the bind process?

 2 6288

Can I use LOCK TABLE on a view?

 1 6210

Are views updatable ?

 4 10284

Give some example of statistics collected during RUNSTATS?

 1 5174

What is referential integrity?

 5 18273

What is EXPLAIN?

 1 4905

Un-Answered Questions { IBM MainFrame }

What is a run unit?

990

What is dpf in db2?

660

What is the function of logging in the db2 database?

636

In COBOL programming, what is PERFORM? What is VARYING?

664

List the type of locks and explain each of them.

525




What are the mainframe computing pros and cons?

612

How many bytes S(8) comp field occupy and its maximum value?

1621

Explain the contention situations caused by locks?

585

How many ways are there for initiating a transaction?

582

What is icm instruction?

637

Can you define path?

580

Explain about run unit currency?

502

How errors are handled in CICS programs?

635

Are scope terminators compulsory? If they are, when?

487

Who uses db2?

569

For More Un-Answered { IBM MainFrame } Questions Click Here