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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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
can primery key be a non clustered index?
 Question Submitted By :: Gouthamraju
I also faced this Question!!     Rank Answer Posted By  
 
  Re: can primery key be a non clustered index?
Answer
# 1
No. If a table have primary key column automatically it is
clustered index. if a table have other than primary key 
it have non clustered index. so answer of the question is it
doesn't support non clustered index in the primary key column
 
Is This Answer Correct ?    17 Yes 6 No
Raju
 
  Re: can primery key be a non clustered index?
Answer
# 2
No
 
Is This Answer Correct ?    11 Yes 5 No
Candu
 
 
 
  Re: can primery key be a non clustered index?
Answer
# 3
No, its not possible to hving Primary key with Non Clusterd 
Index, because whenever we have to make a column as Primary 
Key, it will create a Clusterd Index on that Column 
automatically, it is due to the concept of paging, thats 
why we can have only 1 primay key and 1 clusterd index per 
Table...Enjoy :-)
 
Is This Answer Correct ?    9 Yes 3 No
Hiral Bhatt
 
  Re: can primery key be a non clustered index?
Answer
# 4
Primary cannot be a non clustered index because when you 
are creating primary key on a column then by defualt 
cluster index will created on that column.
 
Is This Answer Correct ?    5 Yes 3 No
Navneet Sharma
 
  Re: can primery key be a non clustered index?
Answer
# 5
No, its not possible to hving Primary key with Non Clusterd 
Index, because whenever we have to make a column as Primary 
Key, it will create a Clusterd Index on that Column 
automatically, it is due to the concept of paging, thats 
why we can have only 1 primay key and 1 clusterd index per 
Table...Enjoy :-)
 
Is This Answer Correct ?    3 Yes 3 No
Praveen
 
  Re: can primery key be a non clustered index?
Answer
# 6
Primary key is also known as clusterd index which is 
physical structure .And noncluster index is logical 
structure .

therefore Primary key cant be a nonclustered index. and 
when we are creating primary key on a table system 
understands it as creation of clustered index.

this is the reason one table can have one primary key
 
Is This Answer Correct ?    0 Yes 3 No
Samar
 
  Re: can primery key be a non clustered index?
Answer
# 7
Yes it is possible that a primary key can be non clustered 

create table abc(eid int PRIMARY KEY 
NONCLUSTERED,ename varchar(50),vid int)

create clustered index abc_clustered on abc (vid)


now if you will check the index on eid cloumne it will be 
unique and vid will have a clustered index.

Give it a try if you don't belive......
 
Is This Answer Correct ?    11 Yes 0 No
Devendra Sharma
 
  Re: can primery key be a non clustered index?
Answer
# 8
yes, it is possible
 
Is This Answer Correct ?    0 Yes 0 No
Ivee
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are constraints? Explain different types of constraints?  6
What is Transaction?  2
select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.  7
I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top. Techno-Solutions3
can you any body tell me which service pack is installed in the sql server?  3
Which stored procedure will you be running to add a linked server?  1
What are cursors? Name four types of cursors and when each one would be applied? Adea-Solutions1
what are the problems in logshipping?  2
wht's the differece between sqlserver05 and sqlserver2000  3
The Difference between 'Count' and 'Count(*)'  12
What is the difference between UNION and UNIONALL? CTS2
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds5
how to change column into row in sql ESS2
How to Get the last identity value used  4
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?  3
where do you use Isolations?give me some exmpale?  1
What is a join and their types? Challenger-Financial2
What are three SQL keywords used to change or set someone?s permissions?  3
What are mdf,ndf,ldf files and how to see the data in those files? Accenture5
What is an execution plan? When would you use it? How would you view the execution plan?  1
 
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