.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Jean Paul
SP
satyapriyanayak
Ashutosh Jha
Simon Robert VoIP


Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Post New Question Subscribe to Interview Questions
 
Quick Links For Interview Questions Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  OOPs  JQuery  JavaScript/VBScript
BiztalkPatten/Practices.IISWCFWPFWWF
NetworkingAptitudeOthers  All    
 

Interview Questions And Answers

What are different Types of Join?

Author: Nargani          Posted Date: July 22, 2014    Category: Sql Server     Points: 40


Cross Join

A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table. The common example is when company wants to combine each product with a pricing table to analyze each product at each price.

Inner Join

A join that displays only the rows that have a match in both joined tables is known as inner Join. This is the default type of join in the Query and View Designer.

Outer Join

A join that includes rows even if they do not have related rows in the joined table is an Outer Join. You can create three different outer join to specify the unmatched rows to be included:

. Left Outer Join: In Left Outer Join all rows in the first-named table i.e. "left" table, which appears leftmost in the JOIN clause are included. Unmatched rows in the right table do not appear.
. Right Outer Join: In Right Outer Join all rows in the second-named table i.e. "right" table, which appears rightmost in the JOIN clause are included. Unmatched rows in the left table are not included.
. Full Outer Join: In Full Outer Join all rows in all joined tables are included, whether they are matched or not.

Self Join

This is a particular case when one table joins to itself, with one or two aliases to avoid confusion. A self join can be of any type, as long as the joined tables are the same. A self join is rather unique in that it involves a relationship with only one table. The common example is when company has a hierarchal reporting structure whereby one member of staff reports to another. Self Join can be Outer Join or Inner Join.

What are the different ways to generate proxy in WCF?

Author: Nargani          Posted Date: July 18, 2014    Category: WCF     Points: 40

A service proxy or simply proxy in WCF enables application(s) to interact with WCF Service by sending and receiving messages. It's basically a class that encapsulates service details i.e. service path, service implementation technology, platform and communication protocol etc. It contains all the methods of service contract (signature only, not the implementation). So, when the application interact the service through proxy, it gives the impression that it's communicating a local object.

We can create proxy for a service by using Visual Studio or SvcUtil.exe.

Generating proxy using Visual Studio is simple and straight forward.

->Right click References and choose "Add Service Reference".
->Provide base address of the service on "Add Service Reference" dialog box and click "Go" button. Service will be listed below.
->Provide namespace and click OK.

Visual studio will generate a proxy automatically.

We can generate proxy using svcutil.exe utility using command line. This utility requires few parameters like HTTP-GET address or the metadata exchange endpoint address and a proxy filename i.e. optional.

svcutil http://localhost/MyService/Service1.svc /out:MyServiceProxy.cs
If we are hosting the service at a different port (other than default for IIS which is 80), we need to provide port number in base address.

svcutil http://localhost:8080/MyService/Service1.svc /out:MyServiceProxy.cs

What's the difference between a clustered and a non-clustered index

Author: Ashutosh Jha          Posted Date: July 01, 2014    Category: Sql Server     Points: 40

A clustered index directly affects the way tabled data is stored on a specific disk. This means that when a clustered index is used, data is stored in sequential rows based on the index column value. This is why a table can only contain a single clustered index. Non-clustered indexes directly affect the way physical data is stored and managed within SQL Server.

What is the lifecycle of a Message in BizTalk server

Author: Ashutosh Jha          Posted Date: June 30, 2014    Category: Biztalk     Points: 40

A message is received through a receive location defined in a given receive port. This message is processed by the pipeline associated with the receive location, and if there are any inbound maps associated with the receive port they are executed. The resulting message is then published to the MessageBox database. The MessageBox evaluates active subscriptions and routes the message to those orchestrations, and send ports with matching subscriptions. Orchestrations may process the message and publish messages through the MessageBox to a send port where it is pushed out to its final destination.

Which Interfaces do you need to implement in a disassembling custom pipeline component

Author: Ashutosh Jha          Posted Date: June 30, 2014    Category: Biztalk     Points: 40

A disassembling pipeline component receives one message on input and produces zero or more messages on output. Disassembling components are used to split interchanges of messages into individual documents. Disassembler components must implement the following interfaces:

IBaseComponent.
IDisassemblerComponent.
IComponentUI.
IPersistPropertyBag.

How to route binary data

Author: Ashutosh Jha          Posted Date: June 30, 2014    Category: Biztalk     Points: 40

To route binary data you can use pass-through pipelines on the receive location and send port. BizTalk will route (copy) the data from the source (receive location) to the destination (send port). If you want to route the binary data based on some information in the binary data then you write a custom Disassembler to promote the properties you need from the incoming message to route the binary data.

Does BizTalk support synchronous communication

Author: Ashutosh Jha          Posted Date: June 30, 2014    Category: Biztalk     Points: 40

BizTalk Server architecture is asynchronous for scalability reasons. However, the architecture of the BizTalk Messaging Engine enables exposing a synchronous message exchange pattern on top of these asynchronous exchanges. To do this, the engine handles the complex task of correlating the request and response messages across a scaled-out architecture by linking together a number of asynchronous message exchanges to expose a synchronous interface.

How can we give face effect in jQuery

Author: Ashutosh Jha          Posted Date: June 30, 2014    Category: JQuery     Points: 40

In jQuery we have three methods to give the fade effect to elements: fadeIn, fadeOut and fadeTo
. This methods change the opacity of element with animation.

Syntax:

$(selector).fadeIn(speed,callback)
$(selector).fadeOut(speed,callback)
$(selector).fadeTo(speed,opacity,callback)
."speed" can be one of following values : "slow", "fast", "normal" or milliseconds
."opacity" specify the value that allows the fading to given opacity.
."callback" is the function which we want to run once the fading effect is complete.

What is jQuery Selectors

Author: Ashutosh Jha          Posted Date: June 30, 2014    Category: JQuery     Points: 40

jQuery Selectors are used to select one or a group of HTML elements from your web page.
. jQuery support all the CSS selectors as well as many additional custom selectors.
. jQuery selectors always start with dollar sign and parentheses: $()
. There are three building blocks to select the elements in a web document.

Select elements by tag name
Select elements by ID
Select elements by class

What are the differences between jQuery and JavaScript?

Author: Ashutosh Jha          Posted Date: June 30, 2014    Category: JQuery     Points: 40

JavaScript is language; jQuery is a library written in that language. We can say that jQuery is one of many particular instances of the JavaScript language.
« Previous12345678910….451452Next »


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend