KyaPoocha.com

Related Interview Questions

• What is the different between index and subscript ?  06.09.08

  Subscript refers to the array of occurrence , where as Index represents an occurrence of a table element. An index can only modified using perform, search & set...

• If you were passing a table via linkage, which is preferable - a subscript or an index ?  27.08.08

  Wake up - you haven't been paying attention! It's not possible to pass an index via linkage. The index is not part of the calling programs working storage. Thos...

• What is the difference between a subscript and an index in a table definition ?  27.08.08

  A subscript is a working storage data definition item, typically a PIC (999) where a value must be moved to the subscript and then incremented or decrements by...

• What is the difference between index and subscript ?  27.08.08

  Subscript refers to the array occurrence while index is the displacement (in no of bytes) from the beginning of the array. An index can only be modified using P...

• What is the different between index and subscript ?  08.08.08

  Subscript refers to the array of occurrence , where as Index represents an occurrence of a table element. An index can only modified using perform, search &...

• What is the difference between a subscript and an index in a table definition ?  03.08.08

  A subscript is a working storage data definition item, typically a PIC (999) where a value must be moved to the subscript and then incremented or decrements by...

• What is SSRANGE, NOSSRANGE ?  31.07.08

  These are compiler options with respect to subscript out of range checking. NOSSRANGE is the default and if chosen, no run time error will be flagged if your in...

• What is the basic difference between clustered and a non-clustered index ?  23.07.08

  The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index i...

• What is the difference between TYPE 1 index & TYPE 2 index ?  26.03.08

  TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2 index is the option which comes with DB2V4. With TYPE 2 index data can be retrie...

• What is index ?  16.03.06

  INDEX is a general term for an ORACLE / SQL feature used primarily to speed execution an impose UNIQUENESSÂ upon certain data. INDEX provides a faster access m...