Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



IBM MainFrame Interview Questions
Questions Answers Views Company eMail

Name the different types of Table spaces.

IBM,

5 15432

How do you retrieve the data from a nullable column?

2 8830

What is a clustering index ?

3 7531

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

1 7062

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 9108

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

1 5262

What is a host variable?

3 6892

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 10312

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

1 5071

What information is used as input to the bind process?

2 7457

Can I use LOCK TABLE on a view?

1 6884

Are views updatable ?

4 12627

Give some example of statistics collected during RUNSTATS?

1 5874

What is referential integrity?

5 19928

What is EXPLAIN?

1 6188


Un-Answered Questions { IBM MainFrame }

Tell me how many alternate indexes you can have on a dataset?

1101


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1107


What is the function of the dd avgrec keyword in sms datasets?

1343


What is the difference between lds and esds?

1048


in a cobol select statement for a ksds can you tell me what are the 3 possibilities for access?

1205


What do you mean by an alias?

1083


Explain the mdt in cics?

1166


How many root segments do we have per database record?

1039


how to convert the recors form vsam file to db2 table tru file aid

3265


I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK

1946


What is the quality process in development?

1086


What are the different types of table spaces?

1000


What does the sample library of uni-rexx consist of?

1072


What is the use of db2 optimizer?

1117


What is the term bms in cics?

1220