Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?

I often see people getting confused between Primary Key and Unique Key. I see where people get confused about the same. Let us discuss. Question: “What is the Difference Between Primary Key Constraints and Unique Key Constraints?” Answer: “Primary Key (PK) Constraints enforce uniqueness just like Unique Key (UK) Constraints,…
Read More

Interview Question of the Week #008 – Write Scripts to Convert String to Title Case or Proper Case

Just received a question in an email asking questions about how to Convert String:

“I just got out of the interview and I was asked to write scripts to convert a string to Title Case. I was also asked to refer to the website over here to validate my answer after I complete writing script.

Do you think it is not fair to ask such questions in an interview?”

Read More

Interview Question of the Week #006 – Is Shrinking Database Good or Bad?

Here is the most debated Interview Question – Is Shrinking Database Good or Bad? I will try to answer this in a single statement – “Shrinking Database is bad practice for performance as it increases fragmentation. It should be used in rare cases of running out of space on drive.” I believe above…
Read More