Monthly Archives: November 2010

Again with one more post for interview questions for freshers. I am currently just giving the few more questions to memorize.Again these are few basic questions for writing simple queries. These questions will around simple TSQL syntaxes and mechanics to … Continue reading →

Fresher’s is the word which could some time give you gain and can also give pain sometime while searching the job. Mostly when people interviews a fresher they expect the basic knowledge but still there is confusion in the definition … Continue reading →

Question: What is View? Answer: View is collection of one or more related tables. It’s getting the selected columns which are required from different tables in to one table. View is a de normalized representation data.Types of View: 1.       Normal … Continue reading →

Below are the Interview view questions related to user defined database object View. View is the basic user defined object or you can say the first object which we create as user defined object after tables. Before creating the view … Continue reading →

Below are the possible Interview Questions related to joins in SQL Server.  The future post will have brief description about all joins these questions. Joins comes under the SQL Server basics i.e. it’s the first thing which interviewer looks from … Continue reading →