Answer Posted / samar
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 ? | 1 Yes | 4 No |
Post New Answer View All Answers
What do you understand by replication in sql server? Mention the different types of replication in sql server.
what are the different types of replication you can set up in sql server? : Sql server database administration
Explain about nested stored procedure?
What are page splits?
Explain the properties of the relational tables?
What is compression - row-level and page-level compression?
What are the limitations/drawbacks or ssrs 2008 r2?
Does the unique constraint create an index?
Which sql server table is used to hold the stored procedure script?
Explain what are the different index configurations a table can have?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Explain different forms of normalization?
How many instances per computer are there in sql server 2000?
What is the maximum size of column in sql server?
How many clustered indexes there can be on table ?
