Question of the Week -08/04/2014
Suppose we need to find out the name of all the months in a given year (Year will be given…
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)…
Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the…
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 clustered…
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…
Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname…