MainFrame Interview Questions
Questions Answers Views Company eMail

Explain the use of the WHERE clause.

IBM,

2 4199

What is index cardinality?

3 9658

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

IBM, Tech Mahindra,

2 10432

What are the three types of page locks that can be held?

1 3904

What is the meaning of -805 SQL return code?

3 11256

What is a base table?

2 3891

what's the best lock size that you could use when you create a tablespace?

IBM,

2 4875

How would you print the output of an SQL statement from SPUFI?

2 7561

What is the STOSPACE Utility used for?

1 5778

Where besides the DB2 catalog is database object information stored by DB2?

1 4261

What is isolation level?

4 5711

What is a predicate?

1 3976

What is ALTER ?

3 5644

What do you need to do before you do EXPLAIN?

1 4468

How do you insert a record with a nullable column?

2 5270


Un-Answered Questions { MainFrame }

what is a physical file?

1009


Enlist the features of rexx as a programming language.

625


what will happen if there is no secondary allocation made for datasets?

622


What is the function of dd disp parameter?

658


Explain the contention situations caused by locks?

594






explain icm instruction?

661


What is z os in mainframe?

559


What is cobol db2?

570


. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?

7045


what is the sequence when using cursor?

607


what is the use of outrecord?

1772


Define predicate?

645


Explain index cardinality?

555


Is ibm db2 open source?

589


Name the cics command used to access current date and time?

574