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 as an input parameter) where...
Answer – Objective Question (How many Null values in an unique constraint can be inserted in SQL Server)
Question:- How many NULL value allowed in a column in which Unique constraint is defined in SQL Server? Options:- a) 1 b) 2 c) More than...
Question of the Week – 11/1/2014
Question:- Suppose there are two tables A and B and we need to write 3 SQL queries which returns the record set as shown in the below...
Answer – Objective Question (In which database temporary tables are created in SQL Server)
Question :- In which database temporary tables are created in SQL Server? 1) User database (where temporary table are defined) 2) Master database...
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 defined in the organization to...
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 index (Correct Answer) 3)...
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 defined in the organization to...
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 3) 999 (Correct answer) 4)...
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 rows contains “Vivek Johari” and the...
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 nvarchar(150)) Suppose it contains the...