January 2014

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

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 rows