You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?


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

Post New Answer

More SQL Server Interview Questions

How to check table values in sql server?

0 Answers  


What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,


What is triggers and its types?

0 Answers  


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

0 Answers  


write sql program to get the detail of student in a class?

2 Answers  






What is use of except clause? How it differs from not in clause?

0 Answers  


Describe the left outer join & right outer join. : sql server database administration

0 Answers  


Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,


What is an etl file?

0 Answers  


What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  


Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  


Categories