Answer -Question of the Week – 2/1/2014 – Question 1
Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation…
Answer – Objective Question (Which table is called Heap table in SQL Server)
Question:- Which table is called Heap table in SQL Server. 1) Table without any indexes 2) Table without any clustered…
Question of the Week – 2/1/2014 – Question 1
Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation…
Answer – Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)
Question :- How many non clustered indexes are possible in a table in SQL Server 2008R2 1) 1 2) 249…
Answer – Question of the Week – 28/12/2013 – Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5…
Deleting Duplicate rows using CTE
Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is…
Answer -Question of the Week – 25/12/2013- Question 1
Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname…
Question of the Week – 28/12/2013 – Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5…
Question of the Week -25/12/2013- Question1
Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))…
Interview Questions on Sql Server -Part 3
1. What are the Sql Joins? Sql Joins are the way to get data from many tables based on some…