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