Translate

Friday, August 31, 2012

Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY

SELECT yourcolumns
FROM tablenames
JOIN tablenames
WHERE condition
GROUP BY yourcolumns
HAVING aggregatecolumn condition
ORDER BY yourcolumns

Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY

SELECT yourcolumns
FROM tablenames
JOIN tablenames
WHERE condition
GROUP BY yourcolumns
HAVING aggregatecolumn condition
ORDER BY yourcolumns

What is Session Identifier?

Session Identifier is used to identify session. It has SessionId property. When a page is requested, browser sends a cookie with a session identifier. This identifier is used by the web server to determine if it belongs to an existing session or not. If not, a Session ID (120 - bit string) is generated by the web server and sent along with the response.

Difference between Session object and Profile object in ASP.NET?


Profile
-------
1.Profile object is persistent.
2.Profile object uses the provider model to store information.
3. Profile object is strongly typed.
4. Mostly used for anonymous users.

Session 
--------
1.Session object is non-persistant.
2.Session object uses the In Proc, Out Of Process or SQL Server Mode to store information.
3. Session object is not strongly typed.
4. Used for authenticated users.

difference between Char Vs nChar Vs Varchar


Char :
Fix length memory storage
Char takes up 1 byte per character

NChar : Nchar takes Unicode data

Varchar :
Variable length memory storage
varchar rakes 1 byte for character and +2 bytes to hold length information

Difference between debug and trace


Trace statements are included by default when the program is compiled in to release build,where as debug statements are not.The Debug class is used for debugging,however, the Trace class is used for testing and optimization even after an application is compiled and released.

What is difference between interface inheritance and class inheritance

interface inheritance is a misleading term. Interface inheritance would be equivalent to the union of the method signatures of interfaces ( no typo here, an interface may implment multiple other interfaces)

Class inheritance - single hierarchy (in C#), and not only the methods are inherited, but also the data members. (interface in C# cannot define data members)

What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET

Plz provide the answer

What are WSDL ports


 element defines an individual endpoint by specifying a single address for a binding.
Here is the grammer to specify a port:

    



  • The port element has two attributes - the name attribute and the binding attribute.
  • The name attribute provides a unique name among all ports defined within in the enclosing WSDL document.
  • The binding attribute refers to the binding using the linking rules defined by WSDL.
  • Binding extensibility elements (1) are used to specify the address information for the port.
  • A port MUST NOT specify more than one address.
  • A port MUST NOT specify any binding information other than address information.

What is the difference between session state and session variables

Plz give your answer

What are the different types of caching?

Output Caching: Output caching is useful when the contents of an entire page can be cached. While a page is cached by the output cache, subsequent requests for that page are served from the output page without executing the code that created it.

Fragment Caching: Sometimes it is not practical to cache an entire page - perhaps portions of the page must be created or customized for each request. In this case, it is often worthwhile to identify objects or data that are expensive to construct and are eligible for caching. Once these items are identified, they can be created once and then cached for some period of time. Additionally, fragment caching can be used to cache regions of a page's output.

Data Caching: Data caching is storing data in memory for quick access. Typically information that is costly to obtain (in terms of performance) is stored in the cache. One of the more common items stored in a cache is commonly displayed database values; by caching such information, rather than relying on repeated database calls, the demand on the Web server and database server's system resources are decreased and the Web application's scalability increased. The cache items can be given an expiration policy that causes them to be removed from the cache when they have expired. Code that accesses the cache item simply checks for the absence of the item and recreates it, if necessary.