A question was askesd to me in interview

db2 sql interview questions

Moderator: Moderator Group

Post Reply
Shivankoo
Member
Posts: 14
Joined: Mon Dec 13, 2010 4:15 pm

A question was askesd to me in interview

Post by Shivankoo » Fri Sep 21, 2012 10:24 pm

how many databases are possible in db2?
Thanks and Regards
Shivankoo Sharma

//EMPIRE EXEC PGM=WIFE
//SYSIN DD DSN=VARSHA.ME.HOME,DISP=SHR
//SYSOUT DD DUMMY

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Sat Sep 22, 2012 2:58 pm

Your answer was?
Your answer now that you have looked it up in the manuals?
Regards
Nic

Shivankoo
Member
Posts: 14
Joined: Mon Dec 13, 2010 4:15 pm

Post by Shivankoo » Sat Sep 22, 2012 3:23 pm

My ans was :shock:
After looking in manuals I came to know that its 65279
Thanks and Regards
Shivankoo Sharma

//EMPIRE EXEC PGM=WIFE
//SYSIN DD DSN=VARSHA.ME.HOME,DISP=SHR
//SYSOUT DD DUMMY

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Sat Sep 22, 2012 4:35 pm

"More than enough for all purposes for which DB2 is useful. If you want to know the exact figure I'd look in" and then name the manual where you are likely to find it.

I'm not convinced that being able to give the answer off the top of your head would demonstrate much - or, conversely, demonstrate a lack of knowledge.

You need to know which manual to look in for which type of information. The "Table of Contents" for each is very useful for this.

For a "normal" question, that you may be faced with day-to-day, you could be expected to know the answer. This type of question, to me, is a bit dumb and the answer might indicate little to anyone genuinely wanting to know if you know DB2.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others