Answer Posted / hari
Primary key : Doen't allow null values
Unique key : allow one null value
Primary key create cluster index
Unique Key create non-cluster index
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the fastest way to permanently delete a 1 million row table named customers?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Is it important for a database administrator to understand the operating system and file access?
Do you know what is rank function?
Other than truncate statement, which other command can by-pass the trigger on the tables?
How to recreate an existing index in ms sql server?
Will the writetext statement activate a trigger?
What happens if you delete a table that is used by a view?
How to write a query with a right outer join in ms sql server?
How to enforce security in sql server? : sql server security
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What are the joins in sql server? : sql server database administration
Explain the rules for designing files and file groups in sql server?
What happens when transaction log is full?
Where are sql server usernames and passwords stored in the sql server?