Home

Ask Questions

Feed Back

My Questions

Contact Us

About Us

Interview Questions

Testing Tools
Testing
Web
Clarify CRM
Oracle Apps
JCL
DB2
VSAM
IDMS
COBOL
Payroll
Fixed Assets
Cashier
Accounts Receivables
Supervisory
General Ledger
Cost Accounting
Audit
Accounts Payable
Quantitative
Oracle
General
Logical and Aptitude
Telecommunications
8085
Bluetooth
Hardware
General
Siebel
SAP R-3
PeopleSoft
Oracle
Operating Systems
Networking
Languages
J2EE
Microsoft
Database
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.

Question:	Which of the following statements correctly describe stored procedure result sets? A. The cursor name for the result set must be returned as a parameter. B. A stored procedure cannot contain multiple result sets. C. The cursor defining the result must be declared using the WITH RETURN clause. D. Each column specified in cursor defining the result set must be defined in the parameter list of the stored procedure. E. The client program can execute the UPDATE WHERE
Rating:
View Answer:	Here

Question:	How to write store Procedure for insert of values by using COBOL,DB2 Programs?
Rating:
View Answer:	Here

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
Rating:
View Answer:	Here

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

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

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

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

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

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

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

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

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

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.
Rating:
View Answer:	Here

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

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?
Rating:
View Answer:	Here

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

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

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

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

Question:	What is a clustered index?
Rating:
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

Restricted mode is a mode of DB where instance is started and only DBA can access the instance.

It is nothing but an electronic devices used for connecting any wireless applications.

SQRW, cmd line, process schedular.

Moving from one BTS to another BTS with out dropping the call is called HANDOVER but it is only used in GSM, in case of CDMA we use HANDOFF mechanism.

ALL THE FACTORS WHICH ARE AFFECTING THE HUMAN RELATIONS OF A COMPANY IS UNDER THE DEFINITION OF HUMAN RESOURCE.

Use Regularexpression Validator and custom the format what you want set to that text box.

int count1s =0; while(num != 0){ if(num & 1 == 1){ count1s++; } num= num>>1; } printf("%d", count1s);

use regular expression validation.

Using datasets,we can get the data and to display we can use the grid view.

Accounts payable is where the payment is made regarding payment to the invoices/bill.

Newinterviewquestions.com is a part of Vyom Network.

Copyright © 2009, newinterviewquestions.com. All rights reserved Privacy Policy | Terms and Conditions

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

Download Yahoo Messenger | Web Hosting