IBM DB2 Interview Questions and Answers

All Categories >> Databases Programming >> IBM DB2 >> ▼

DB2 is one of the families of relational database management system (RDBMS), DB2 Interview Questions and Answers will guide us that DB2 software products within IBM's broader Information Management Software line. Although there are different "editions" and "versions" of DB2, which run on devices ranging from handhelds to mainframes, most often DB2 refers to the DB2 Enterprise Server Edition, So get start learning IBM DB2 with DB2 Interview Questions with Answers Guide

  1. IBM DB2 questions updated at 01 Jul 10 in Category Databases Programming and visited 1077 Times

IBM DB2 Questions and Answers:

1 :: What is sqlcode -811?

SELECT statement has resulted in retrieval of more than one row.
0/5 Rating (0 vote)
Is This Answer Correct?    3 Yes 0 No
Place Your Answer

2 :: What is sqlcode -922 ?

Authorization failure
0/5 Rating (0 vote)
Is This Answer Correct?    1 Yes 0 No
Place Your Answer

3 :: What is the difference between primary key & unique index ?

Primary : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.

Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table
0/5 Rating (0 vote)
Is This Answer Correct?    2 Yes 0 No
Place Your Answer

4 :: What is a clustering index ?

Causes the data rows to be stored in the order specified in the index. A mandatory index defined on a partitioned table space.
0/5 Rating (0 vote)
Is This Answer Correct?    2 Yes 0 No
Place Your Answer

5 :: A user
defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.

In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.

100 ( for successful completion of the query ), 0 (for successful COMMIT if AUTOCOMMIT is set to Yes).
0/5 Rating (0 vote)
Is This Answer Correct?    0 Yes 0 No
Place Your Answer

Rate This Category:
0/5 Rating (0 vote)
 Place Your Question



Top: IBM DB2 Interview Questions and Answers
IBM DB2 Interview Questions and Answers

Top Frequently Asked IBM DB2 Question
Frequently Asked IBM DB2 Job Interview Question


Top Frequently opened Databases Programming Job Interview categories
Most popular Databases Programming Job Interview categories

Comments About IBM DB2 Interview Questions and Answers

Share your valuable opinions, ideas and suggestions about IBM DB2 Interview Questions and Answers
While placing your comment your email address is required but won't be published any where else; Personal information will be kept confidential; we do not sell or release our respective visitors private information.

  1. Webmaster 22nd of May 2012

    Webmaster Said

    Tell us what you feel about IBM DB2 Interview Questions and Answers
    All comments will be published after review. No login or registration is required to post a comment on IBM DB2 Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
    So start sharing your thoughts regarding IBM DB2 Interview Questions and Answers
    Thank you.

    Reply

Leave a Comment

Leave a Comment
  4.  Enter This Verification Code  Regenerate Verification Code  



Your reply will be added to the comment above (Below any other replies to this comment) -

Top Comments About: IBM DB2 Interview Questions and Answers
Comments on IBM DB2 Interview Questions and Answers

 
Top of Link batk to IBM DB2 Interview Questions and Answers
Link batk to IBM DB2 Interview Questions and Answers

Privacy Policy | Terms and Conditions | Contact Us »