Category Archives: SQL Server Interview Questions and Answers

Question: What is NO COUNT used for? Answer: It’s used to check whether the sql statement executed successfully or not. When no count is on than this message will not return and while it off then sql server returns the … Continue reading →

Question: How many columns can be used with roll up or with cube command? Answer: 10 columns Question: How many clustered index can be created on the table? Answer: Only one clustered index can be created. Question: How many columns … Continue reading →

Question: What are dynamic queries? Answer: Dynamic Queries are the query in which logic can be change at run time. These queries are created by using the variables. Question: What is distinct clause? How it works? Answer: Distinct clause is … Continue reading →

Question: What is the User defined functions? Answer: User defined functions are the objects which used to for performs some particular task or retrieves some particular data. Function always returns some values. Question: What are the difference types of UDF? … Continue reading →

Question: What is common table expression (CTE)? Answer: CTE is a new feature introduced in SQL Server 2005. CTE is a virtual view which exists at runtime. It can be used for the logic which need to be used other … Continue reading →

Question: What is select statement in TSQL? Answer: It’s an elementary question but the beginners can go through face this kind of questions i.e. fresher’s having no experience. Select statement is the first keyword in any query. It used to … Continue reading →

Question: What are the different types of data types in SQL Server? Answer: There are different types of data types used in SQL Server 1.          Int 2.          Small int 3.          Big int 4.          Tiny int 5.          Float 6.          Double 7.          … Continue reading →

Question: What are unique identifiers in SQL Server? Answer: The columns which are created as a data type unique identifier, contains the hexadecimal value which populates automatically. This value is used for segregating the data in rows where there is … Continue reading →

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 →