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 15635

How do you retrieve the data from a nullable column?

2 8941

What is a clustering index ?

3 7675

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

1 7143

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 9212

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

1 5358

What is a host variable?

3 7045

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 10416

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

1 5158

What information is used as input to the bind process?

2 7559

Can I use LOCK TABLE on a view?

1 6965

Are views updatable ?

4 12868

Give some example of statistics collected during RUNSTATS?

1 5956

What is referential integrity?

5 20143

What is EXPLAIN?

1 6251


Un-Answered Questions { IBM MainFrame }

What happens when we move a comp-3 field to an edited (say z (9). Zz-)?

1497


Name some translator and compile options and explain their meaning?

2907


We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?

2299


What is nvl in db2?

1160


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1795


What is db2 connect?

1135


Explain in DD statement what is the use of DCB parameter?

1189


Explain the difference between a symbolic map and physical map?

1086


What are the different rules of SORT operation?

1214


how can we repair a soc-7 error?

1094


What is mpp mode?

1191


What is the meaning of the deq command?

1206


How do I change the column size in db2?

1215


what is the responsibility of the construction superintendent

2222


Which commend used for terminating a browser operation?

1055