Interview Questions

A call to onStop method happens when an activity is no longer visible to the user, either because another activity has taken over or if in front of that activity.

It is necessary to understand some of the concepts used extensively in object oriented programming.These include

Objects
Classes
Data abstraction and encapsulation
Inheritance
Polymorphism
Dynamic Binding
Message passing

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.

By default the maximum size is 2MB. and we can change the following
setup at php.iniupload_max_filesize = 2M

A reference variable provides an alias to a previously defined variable.
Data -type & reference-name = variable name

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.

 -1 indicates the field is null

 0 indicates the field is not null

 -2 indicates the field is truncated

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.