Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suresh kaudi
Primary Key: Not allow null values,when we make primary key
automatically create cluster index,primary key we make
other foreign key.
Unique key: allow one null value,we can't make it foreign
key to other table.here we cane make only non-cluster index
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the use of custom fields in report?
How to recover from sql injection? : sql server security
how to take backup bcp out for a column in table in sql server?
explain declarative management framework (dmf) in sql server 2008?
System requirements for sql server 2005 express edition?
Do you know how to send email from database?
What happens if null values are involved in arithmetic operations?
What is the purpose of update statistics and scope_identity() function?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
explain how to create a new schema in a database? : Sql server database administration
What is normalization and what are the advantages of it?
What sql server means?
When we should use and scope of @@identity?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
When a primary key constraint is included in a table, what other constraints does this imply?
