IBM MAINFRAME GURU Forum
  Home      Forum      Online Tutorials      Interview Questions      Mainframe Books      IT News
 


Home  >  Discussion Forum  >  DB2 INTERVIEW QUESTIONS
    

DB2 INTERVIEW QUESTIONS

No of Questions : 142
Goto page Previous  1, 2, 3, 4 ... 13, 14, 15  Next



DB2 INTERVIEW QUESTIONS
DB2 Certification
Question : Hi Every one,

This is my first post in this community.

Please expailn me about DB2 certification. I am 3 years experienced adn wanted to go other company interview.

How can this help me.

Thanks in advance.

View Answer(2)

SQLCODE -811, why always 2nd row is fetched??
Question : hi,

I want to know if their are multiple records(duplicate rows) in a Db2 table,
on fetching it I am getting the 2nd record everytime in my output file..(after handling sqlcode -811)

I want to know why?? why not 1st or 3rd record or any other??

View Answer(5)

block size?
Question : I know that block size is the multiples of logical record length.But what does block size actually mean and for what is it used for?

View Answer(3)

Triggers
Question : When particlar table having Trigger is Dropped .
will trigger also droped or it will remain.?

View Answer(1)

Regarding Cursor
Question : In COBOL-DB2 program without using cursor can we go for any other logic which is more efficient ?

View Answer(4)

FILLER is executable or not?
Question : HI,

can anyone plz clarify my doubt

View Answer(4)

what is the use of OZAGENDB.OZAGENTS when creating the tabl
Question : Hi,
plz clarify my question anyone?

View Answer(0)

Polaris Interview questions
Question : There is one input file and one database is there.we need to create a output file that contains the records which are present in Database and not present in inputfile. Give the logic?

View Answer(1)

VARCHAR
Question : Why VARCHAR should be declare at level no. 49?

View Answer(4)

What is auditing?
Question : What is auditing?

View Answer(6)

Goto page Previous  1, 2, 3, 4 ... 13, 14, 15  Next

Home  >  Discussion Forum  >  DB2 INTERVIEW QUESTIONS


   

IBM MAINFRAME - COBOL Interview Questions( 59 )

IBM MAINFRAME - DB2 Interview Questions ( 110 )

IBM MAINFRAME - JCL Interview Questions( 52 )

IBM MAINFRAME - CICS Interview Questions( 70 )

IBM MAINFRAME - VSAM Interview Questions( 22 )





Google
 
Web mainframegurukul.com









 
Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap    || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1   ||  DB2 Interview questions   || JCL Interview Questions   || COBOL Interview Questions   || VSAM Interview Questions   || CICS Interview Questions   || < simple DB2 SQL tutorial



Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Copyright ? 2005 mainframegurukul.com. All rights reserved