dmca protected sml 120m Answer - Objective Question  (In which database temporary tables are created in SQL Server) Question of the Week

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     3) TempDB (Correct Answer) 4) Model Database 5) None of the above Answer  Thanks to all who attempted this question. 84% people gives the correct answer:-) Correct answer […]

Continue Reading
employee Answer -Question of the Week - 2/1/2014 - Question 1 Question of the Week

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 which each employee can belongs.   For example, Software engineer, Team lead, Project Manager, Project lead, QC engineer, QC Lead, QC manager etc. An employee can belong to one designation […]

Continue Reading
dmca protected sml 120m 1 Answer - Objective Question (Which table is called Heap table in SQL Server) Question of the Week

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) Table without any non clustered Index 4) None of the above Many people attempted this question and mostly gives the correct answer. The correct answer is option 2 ( Table […]

Continue Reading
dmca premi badge 4 Question of the Week - 2/1/2014 - Question 1 Question of the Week

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 which each employee can belongs.  For example, Software engineer, Team lead, Project Manager, Project lead, QC engineer, QC Lead, QC manager etc. An employee can belong to one designation at […]

Continue Reading
dmca premi badge 4 1 Answer - Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2) Question of the Week

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) None of these Explanation  21 people gives answer to this Question and most of them is correct. Correct answer is 999 (Option 4). In SQL Server 2008 onwards, we can […]

Continue Reading
dmca premi badge 4 2 Answer - Question of the Week - 28/12/2013 - Question 2 Question of the Week

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 next 5 rows contains “Abhinav Golwalkar” tbl_charactername ——————— Vivek Johari Vivek Johari Vivek Johari Vivek Johari Vivek Johari Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Now we […]

Continue Reading