Answer Posted / sivasankar k.c
Primary key: it is clustered index. it not allows null
values. Only one primary in each table.
Unique Key: it is non clustered index. Unique key allows
null values.its allows only one null value. More than one
unique key in table.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to create database with physical files specified in ms sql server?
Can another user execute your local temporary stored procedures?
What are group functions in query statements in ms sql server?
Do you know what are the steps to process a single select statement?
What is difference between index seek vs. Index scan?
What are the types of processing and explain each? : sql server analysis services, ssas
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
what is difference between view and Dip.
How many types of the database links?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Which rendering formats are affected by the pagesize properties?
What is the difference between grant and with grant while giving permissions to the user?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
Is null in sql server?
Explain database normalization?