ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How many index keys possible for a table
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How many index keys possible for a table
Answer
# 1
Indexes may be defined as unique or non-unique. A unique 
index acts as a constraint on the table by preventing 
identical rows in the index and thus, the original columns.
 
Is This Answer Correct ?    5 Yes 0 No
Raji
 
  Re: How many index keys possible for a table
Answer
# 2
There can only be one clustered index but multiple non-
clustered index
 
Is This Answer Correct ?    2 Yes 1 No
Namz
 
 
 
  Re: How many index keys possible for a table
Answer
# 3
One table can only one clustered index or primary key and
249 non-clustered index or unique key
 
Is This Answer Correct ?    5 Yes 0 No
Anand K
 
  Re: How many index keys possible for a table
Answer
# 4
In sqlserver we have two types of indexes (1) Clustered (2) 
non clustered indexes. 

Indexes may be simple index or composite index.

Index formed based on single column values is called simple 
index

index formed based on multiple column values is called 
composite index.

Default index is NON CLUSTERED INDEX 

When a table contains a primary key column then sqlserver 
automatically creates a unique clustered index.

Unique--- automatically creates a non clustered index 

so for this reason PRIMARY KEY IS NOT EQUAL TO UNIQUE + NOT 
NULL.
 
Is This Answer Correct ?    2 Yes 0 No
C.jagadish
 
  Re: How many index keys possible for a table
Answer
# 5
250 indexes(1 cluster index,249 non-cluster indexes)
 
Is This Answer Correct ?    3 Yes 1 No
Koti
 
  Re: How many index keys possible for a table
Answer
# 6
four index keys is possible per one table.
read only table u havae create more then index per table
 
Is This Answer Correct ?    1 Yes 0 No
Saravanan
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is row by row processing ?  1
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)  1
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning TCS2
How to Execute an Operating System Command From Within SQL Server ?  2
I have student marks in a student table. I need second highest mark .Then what will the query for this? Wipro23
What are sub-queries? Give example? In which case sub-queries are not feasible? Infosys3
Which institute is best for SQL Server 2005 Training?  5
When do we use the UPDATE_STATISTICS command?  3
what is a cursor and what is its use?  1
What is Covering Indexes? Plz explain with example  2
what command is used to create a table by copying the structure of another table?  5
one table has four field id,name,design,salary. i have to find maximum salary .  6
What is the difference between constraints and triggers? Wipro6
what is advantages in sql 2005 over sql 2000?  4
How do you check the performance of a query and how do you optimize it?  1
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.  2
what is the Enterprise manager(2000) and management studio (2005)?  2
logshipping is Any difference 2000 and 2005?  1
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com