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...
While loop in SQL server
While loop in SQL server Introduction In While loop, we set a condition for the repeated execution of a Code block. So we use while...