What columns would you use as a clustered index on a retail store address table? - On Primary Key column.

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

DATABASE

SQL

DETAILS

Question: What columns would you use as a clustered index on a retail store address table?

Answer: On Primary Key column.

Category	SQL Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8403 users
Added on	11/22/2012
Views	72728
Rate it!

Question: What columns would you use as a clustered index on a retail store address table?

Answer:

On Primary Key column. Source: CoolInterview.com

Answered by: Arshi | Date: 1/21/2008 |

Contact Arshi

It will be store ID where clustered index can be used Source: CoolInterview.com

Answered by: Anant | Date: 5/5/2010 |

Contact Anant

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 is the query for to select multiple columns to generate single row in the sql and how come we can bring grid views in sql for getting those datas are demolished	View Answer
	What is a clustered index?	View Answer
	What is the difference between @@identity and SCOPE_IDENTITY()?	View Answer
	1. How to create a new table? 2. How to insert another column into the table?	View Answer
	What is the use of indexes?Explain about it?	View Answer
	lets i have a table "bapi" having 6 field like this f1 f2 f3 f4 f5 f6 ... ... .. ... ... ... p r o m o d i want to retrive all the data by using select statement and my output will be look like this: xyz ... p r o m o d	f1 f2 f3 f4 f5 f6 ... ... .. ... - SQL Interview Questions & Answers"> View Answer
	what is the difference between replace and translate functions?	View Answer
	How to delete same id in rows? For example empid=5 repeated for times in rows. How to delete which sql query is used?	View Answer
	Difference between decode and case. in which case we are using case and in which case we are using decode? with an example.	View Answer
	How to retrieving the data from 11th column to n th column in a table.	View Answer
	what is the difference between oracle,sql and sql server	View Answer
	on index why u need indexing ? where that is stroed and what u mean by schema object? for what purpose we are using view	View Answer
	I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.	View Answer
	Difference between Stored Procedure and Trigger	View Answer
	When using a count(disitnct) is it better to use a self-join or temp table to find redundant data, and provide an example?	View Answer
	What is the advantage to use trigger in your PL?	View Answer
	What the difference between UNION and UNIONALL?	View Answer
	How to find second maximum value from a table?	View Answer
	How to display duplicate rows in a table?	View Answer
	What is joint?	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 SQL Interview Questions & Answers - Exam Mode / Learning Mode