You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

What is the difference between an index and a unique index?

0 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

What are the five major components of a dbms?

0 Answers  

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

---

What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

---

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

---

What is tempdb in sql server?

0 Answers  

---

How many partitions a clustered index has by default in sql server 2012?

0 Answers  

---