New Interview Questions.com - World's Largest Collection of Interview Questions
  Home  
 
  Ask Questions  
 
  Feed Back  
 
  My Questions  
 
  Contact Us  
 
  About Us  
 
 Interview Questions  


Testing-Tools-interview-questions Testing Tools
Testing-interview-questions Testing
Web-interview-questions Web
Clarify-CRM-interview-questions Clarify CRM
Oracle-Apps-interview-questions Oracle Apps
JCL-interview-questions JCL
DB2-interview-questions DB2
VSAM-interview-questions VSAM
IDMS-interview-questions IDMS
COBOL-interview-questions COBOL
Payroll-interview-questions Payroll
Fixed-Assets-interview-questions Fixed Assets
Cashier-interview-questions Cashier
Accounts-Receivables-interview-questions Accounts Receivables
Supervisory-interview-questions Supervisory
General-Ledger-interview-questions General Ledger
Cost-Accounting-interview-questions Cost Accounting
Audit-interview-questions Audit
Accounts-Payable-interview-questions Accounts Payable
Quantitative-interview-questions Quantitative
Oracle-interview-questions Oracle
General-interview-questions General
Logical-&-Aptitude-interview-questions Logical & Aptitude
Telecommunications-interview-questions Telecommunications
8085-interview-questions 8085
Bluetooth-interview-questions Bluetooth
Hardware-interview-questions Hardware
General-interview-questions General
Siebel-interview-questions Siebel
SAP-R-3-interview-questions SAP R-3
PeopleSoft-interview-questions PeopleSoft
Oracle-interview-questions Oracle
Operating-Systems-interview-questions Operating Systems
Networking-interview-questions Networking
Languages-interview-questions Languages
J2EE-interview-questions J2EE
Microsoft-interview-questions Microsoft
Database-interview-questions Database
Data-Warehousing-interview-questions Data Warehousing

 Our Services  

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies

    • DB2 Interview Questions and Answers

    NEW INTERVIEW QUESTIONS.COM DB2 INTERVIEW QUESTIONS QUESTIONS LISTING

    DB2 Interview Questions & Answers

    A D V E R T I S E M E N T



    [ Page 1] Page 2 Page 3 Page 4 Page 5 Next

    Newinterviewquestions.com: World's Largest Interview Questions Website.
    Questions Question: How to write store Procedure for insert of values by using COBOL,DB2 Programs?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: I have Null value in table i need to write a query so that i can get maximum salary from a pay rool table how i need to handle this type of situation in Application programe as well as SQL query design
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What are foreign keys?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is normalization and what are the five normal forms?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is a DB2 plan?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is a DB2 access path?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is a DB2 bind?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is an alias and how does it differ from a synonym?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is a synonym? How is it used?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is a NULL value? What are the pros and cons of using NULLS?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is the cascade rule and how does it relate to deletions made with a subselect. The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made.
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is a LIKE table and how is it created?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: When can an insert of a new primary key value threaten referential integrity?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What are delete-connected tables?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is the self-referencing constraint?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is a clustered index?
    Ratings Rating:
    View Answer View Answer: Here

    Questions Question: What is meant by index cardinality?
    Ratings Rating:
    View Answer View Answer: Here

    [ Page 1] Page 2 Page 3 Page 4 Page 5 Next

    A D V E R T I S E M E N T

     Sponsors  
    Latest 10 Answers
    Plz can you give me detailed ans.
    JAVA- Just Another Virtual Architecture
    And also defect rate falls below expected. Number of defects fixed
    Requirements traceability Matrix covers all the requirements with all the possible scenarios.
    It is definitely a black box testing technique but here the values or the input data for the test cases is divided into equivalent partitions not teh testt cases.
    Boundary value Analysis is done when you are testing for values. You can perform positive or negative testing for OK button.
    All are true except for the 5th one. I'm not sure about that.
    Encapsulation: Another name for encapsulation is DATA HIDING. It hides the unwanted information using access specifiers.For ex, java-protected, private Abstraction: IT points out the essential characteristics only.
    An operating system is a system software.
    It is an internet standard....

    G o o g l e Search

    Google

    Newinterviewquestions.com is a part of Vyom Network. Top



    Copyright ? 2008, newinterviewquestions.com. All rights reserved Privacy Policy

    Page URL: http://www.newinterviewquestions.com/cat/DB2-interview-questions/Default.asp?cachecommand=bypass


    Download Yahoo Messenger