Interested to Buy Any Domain ? << Click Here >> for more details...
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 is difference between index seek vs. Index scan?
How many types of database relationship in sql server?
Explain about SQLOS?
Write an sql query for deleting duplicate rows?
Explain transaction isolation levels in sql server?
How many categories of functions based their return modes?
What is explicit cursors?
What is the difference between commit and rollback?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is constraints and its types?
What are the types of ssrs?
What are the advantages of paper records?
How to turn on the mssql api module in php?
Why use sub query in sql server and list out types of sub queries?
What do you mean by an execution plan? Why is it used?
