1) How would you find out the total number of rows in a DB2 table? - Use SELECT COUNT(*) ... in db2 query DB2 INTERVIEW QUESTIONS DB2 SQL INTERVIEW Questions

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

MAINFRAME

DB2

DETAILS

Question:

1) How would you find out the total number of rows in a DB2 table?

Answer: Use SELECT COUNT(*) ... in db2 query

DB2 INTERVIEW QUESTIONS
DB2 SQL INTERVIEW Questions

Category	DB2 Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8274 users
Added on	8/31/2014
Views	71369
Rate it!

Question:

1) How would you find out the total number of rows in a DB2 table?

Answer:

Use SELECT COUNT(*) ... in db2 query

DB2 INTERVIEW QUESTIONS
DB2 SQL INTERVIEW Questions Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What are difference between version control and debugging tools?	View Answer
	why we use db2 with cobol why we cant use any other languages? what the main reason? what is disaster recovery?	View Answer
	What do the initials DDL and DML stand for and what is their meaning?	View Answer
	Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.	View Answer
	What are foreign keys?	View Answer
	What is normalization and what are the five normal forms?	View Answer
	What is a DB2 plan?	View Answer
	What is a DB2 access path?	View Answer
	What is a DB2 bind?	View Answer
	What is an alias and how does it differ from a synonym?	View Answer
	What is a synonym? How is it used?	View Answer
	What is a NULL value? What are the pros and cons of using NULLS?	View Answer
	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.	View Answer
	Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?	View Answer
	If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?	View Answer
	What is a LIKE table and how is it created?	View Answer
	When can an insert of a new primary key value threaten referential integrity?	View Answer
	What are delete-connected tables?	View Answer
	What is the self-referencing constraint?	View Answer
	What is a clustered index?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DB2 Interview Questions & Answers - Exam Mode / Learning Mode