Home  
 
  Ask Questions  
 
  Feed Back  
 
  My Questions  
 
  Contact Us  
 
  About Us  
 


 Interview Questions  
 Our Services  

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

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

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


 Sponsors  

Latest 10 Answers
When there is any situation that u should attach a new patch to ur kernel , then download the patch and install it,to make changes to kernel , go to ok prompt and type boot -r, it will update or reconfigure the kernel
Honesty, helpful and reliable
procedure is a set of sql statement ,are combined to gether to perform a specific task or to solve a specifi problem.it does not return value.
leadership is power to influence a group so that the members willingly exert efforts as aspired by the leader.
I have the unique combination of technical skill and the ability to build strong customer relationship. I have the ability to stay focussed in stressfull situation. I would be great addition to your team.
first execute the bc search spec to fetch the data then executes the applet search spec if applet search spec is not match with bc it skips
TCP-Transmission Control Protocol. TCP is Reliable. TCP is Connection oriented. UDP-User Datagram Protoco UDP is Unreliable. UDP is Connectionless.
By default in structure all data member and member function are public,i,e if you not mentation any access specifier. But in case of class By default all data member and member function are private.
Structure is a user defined data type. By default all structure variables are public type and we cann't use access specifier in structure type variable, where as in class we can define objects(variables) under required access specifier type.
variable cost is the cost which is not fixed in nature

Newinterviewquestions.com is a part of Vyom Network. Top



Copyright © 2017, 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 | Dedicated Server | Free SMS Domain Registration | Windows Hosting | Linux Hosting | Java Hosting | Virtual Dedicated Server | Dedicated Server | Reseller Web Hosting | Unlimited Windows reseller hosting | Unlimited Linux reseller hosting | Cheap Windows reseller hosting | Cheap Linux reseller hosting | Cheap Windows hosting | Best Windows hosting | Windows hosting Multiple Domains | Unlimited Windows hosting | Compare hosting plans | Cheap Linux hosting | Best Linux hosting | Linux hosting Multiple Domains | Unlimited Linux hosting | Cheap asp.net hosting | Best asp.net hosting | unlimited asp.net hosting | Cheap asp.net reseller hosting | Unlimited asp.net reseller hosting | Java Features | Cheap Java hosting | Best Java hosting | unlimited Java Hosting | Unlimited Linux reseller hosting | Java Hosting Multiple Domains Quick2host Reviews Buy Online Traffic