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
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is the process of normalising?
How to provide default values to function parameters?
How to delete duplicate rows in sql server?
What are system databases in ms sql server?
Define outer join?
What does executeupdate return?
What is the purpose of linked server configuration in sql server?
Why use sub query in sql server and list out types of sub queries?
How secure is sql server database?
Why do we use stored procedures in sql server?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is difference between count (*) and count 1?
What options are available to audit login activity? : sql server security
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?