Difference between Interface and Abstract Class is favourite question of interviewer while he wants to evaluate your knowledge about Object
[Continue Reading...]For basic Interview Questions of MVC refer my first post of MVC Inter
[Continue Reading...]1. What is main focus in Microsoft's Latest ASP.NET 4.0? Ans. The focus of Microsoft’s latest ASP.NET 4.0 has mainly bee
[Continue Reading...]1. What is Cloud Computing? Ans. Cloud computing is the delivery of computing as a service rather than a product, whereby
[Continue Reading...]1. Write a query for merging two columns into one column on conditional bases(i.e. I want to select Employee Name from any of th
[Continue Reading...]1. What is Windows Azure? Ans. (First Answer)Windows Azure is Microsoft Cloud Computing Operating System. Someone needs to
[Continue Reading...]1. What’s relationship between JavaScript and ECMAScript? Ans. ECMAScript is yet another name for JavaScript (other name
[Continue Reading...]What is Entity Framework? Entity Framework is an additional layer between application and database that enables the deve
[Continue Reading...]What is LINQ? LINQ, or Language INtegrated Query, is a set of classes added to the .NET Framework 3.5. LINQ adds a rich
[Continue Reading...]What is MVC? MVC is a framework methodology that divides an application's implementation into three component roles: mod
[Continue Reading...]Q. What Do you know about SharePoint Object Model? Ans. In Sharepoint Object model there are two Important namespaces.
[Continue Reading...]Q. What are WebParts? Ans. Web Parts are self-contained packages of user interface that can be dropped on
[Continue Reading...]Q. What are the major improvements provided by the common language runtime and the base class libraries? or Q. What are the Major
[Continue Reading...]1. What is SQL Azure? Ans. Microsoft SQL Azure is a cloud-based relational database service that is built on SQL Server te
[Continue Reading...]SQL Server Interview Questions and Answers
1. Write a query for merging two columns into one column
on conditional bases(i.e. I want to select Employee Name from
any of the column FullName or FirstName whichever is not null).
Ans.
To query from two columns conditionally we need to use CASE operator that is provided by SQL Server. Following is the query which depicts how to retrieve conditional value into one column.
1SELECT
Name= CASE
...
1. Define Data Warehouse.
Ans. A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources.
2. Which are three layers in which data warehouse maintains it’s functions?
Ans. A data warehouse maintains its functions in staging, integration and access.
3. Can you elaborate it?
Ans. Staging: It is …