Interview Questions

Suppose we need to find out the name of all the months in a given year (Year will be given

Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server? Options:- a) 1

Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record

Question :- In which database temporary tables are created in SQL Server? 1) User database (where temporary table are defined)

Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation

Question:-    Which table is called Heap table in SQL Server. 1) Table without any indexes 2) Table without any

Question :- Suppose we have to design a database in which employees can work on multiple projects.There are many designation

Question :-  How many non clustered indexes are possible in a table in SQL Server 2008R2 1)  1 2) 249

Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5 rows

Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname

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))