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?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to rebuild the master database?

0 Answers  


What do you understand by a view?

0 Answers  


What are the database roles? : sql server security

0 Answers  


What is the difference between push and pull subscription? : sql server replication

0 Answers  


What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  






what are defaults? : Sql server database administration

0 Answers  


What is difference between drop truncate and delete?

0 Answers  


Can you pass expressions to function parameters?

0 Answers  


Tell me what is sql profiler?

0 Answers  


We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,


how to implement locking in sql server

3 Answers   Satyam,


What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  


Categories