Interview Questions

These objects provide two levels of scope:

Application State

Data stored in the application object can be shared by all the sessions of the application.

Application object stores data in the key value pair.

TCP-Transmission Control Protocol

UDP- user Datagram protocol

UDP is user assisted program and converts the application into the encapsulated form and makes it end point for data to send and then TCP helps in transmission or broadcast!

Example:

"I have several awesome  achievements in my career. Probably the most awesome achievements were the delivery of the most recent version replace update to one of our core products for customer bills. This was a 1-year project and I was one of 9 team members. What made it more for me was that my role expanded from being one of the tech team individuals to taking the lead on building the mobile makings of the product. In order to deliver this aspect of the product, I pulled in 3 new project resources with new specific skills in each of the mobile technology floors we targeted and cross-trained all project resources to support each floor. In the last, our team delivered the product on time and have received numerous accolades, both external and internal. The mobile component was particularly  identified to be world class and distributed the product at its release. Our CEO spent time showing the mobile components to the industry and press and it has since met with superb  reviews. Would you like to see the Android version of the product?"

- Web browser is used to run the software application that allows retrieving, presenting and traversing the information from one place to another. 

- Web browser provides the resources using the WWW (World Wide Web) this can be identified by URI (Uniform Resource Identifier).

- Web browser fetches the data like web page, image, video or other piece of content from the server and displays it accordingly. 

- Web browser uses hyperlinks to display the resources and allow the users to navigate their browsers according to the resources. 

- Web browser defines the application software that is designed for the user to access and retrieve the documents using the Internet.

ASP.NET is a specification developed by Microsoft to create dynamic Web applications, Web sites, and Web services. It is a part of .NET Framework. You can create ASP.NET applications in most of the .NET compatible languages, such as Visual Basic, C#, and J#. The ASP.NET compiles the Web pages and provides much better performance than scripting languages, such as VBScript. The Web Forms support to create powerful forms-based Web pages. You can use ASP.NET Web server controls to create interactive Web applications. With the help of Web server controls, you can easily create a Web application.

Early binding refers to the events that occur at compile time. Early binding occurs when all information needed to call a function is known at compile time. Examples of early binding include normal function calls, overloaded function calls, and overloaded operators. The advantage of early binding is efficiency.

The differences between HTML and XHTML are:

- HTML is application of Standard Generalized Markup Language(SGML) whereas XML is application of Extensible Markup Language(XML).

- HTML is a static Web Page whereas XHTML is dynamic Web Page.

- HTML allows programmer to perform changes in the tags and use attribute minimization whereas XHTML when user need a new markup tag then user can define it in this.

- HTML is about displaying information whereas XHTML is about describing the information.

One of the most common errors that you might face in join statements is 

Server: Msg 4104, Level 16, State 1, Line 1
The multi-part identifier could not be bound.

A multipart identifier is any description of a field or table that contains multiple parts - for instance MyTable.SomeRow - if it can't be bound that means there's something wrong with it - either you've got a simple typo, or a confusion between table and column. It can also be caused by using reserved words in your table or field names and not surrounding them with [].

The main reason for this error is that the source table cannot be found, for example if you have statement such as Table1.OrderDate, and then if you get error above, this means that Table1 cannot be found in the query. Sometimes you can see that source table exists in the query, but T-SQL cannot understand it, especially when you write join statements.