Answer Posted / sunil kumar mishra
Primary key is a particular coloum that is unique in every
tuple is called primary key and ofenly it does not support
null values since it is used to uniquely identitfy row in a
table(Relation) and automatically does go to replace into
clustered index and support distinct value and Each table
should have a primary key, and each table can have only one
primary key.(Primary keys must contain unique values)
Unique value-
Unique values is same, in some manner, primary key since
You can have many UNIQUE constraints per table but primaty
key kan have one in each table.it support nonClustered
index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe how to use linked server?
How you trouble shoot when any job fails
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Give main differences between "Truncate" and "Delete".
Does a server store data?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is a trigger in sql server?
What are drillthrough reports?
Mention what are the core components of ssrs?
How to include text values in sql statements?
What is the difference between indexing and hashing?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is difference between order by and group by?
What is the difference between SQL notification and SQL invalidation?