Interview Questions

In a nutshell, a temp table is a temporary storage structure. It means you can use a temp table to store data temporarily so you can manipulate and change it before it reaches its destination format.

In table_user.gender column change ‘male to female’ and ‘female to male’ in one SQL statement.

UPDATE table_user

SET gender =

CASE gender

WHEN ‘male’ THEN ‘female’

WHEN ‘female’ THEN ‘male’

ELSE gender

END

The System.xml.dll is the real physical file, which contains the XML implementation. Some of the other namespaces that allow .NET to use XML are as follows:

      =>  System.Xml

      =>  System.Xml.Schema

      =>  System.Xml.XPath

      => System.Xml.Xsl

In a Ethernet network, between any two points on the network, there can be no more than five network segments or four repeaters, and of those five segments only three of segments can be populated.

We can say that sales promotion is a cost effective technique by which an organisation can achieve its sales volume or the marketing objectives by providing value added product and not just an ordinary product to the end user or even the intermediaries. It is short term by nature and is suitable enough for generating sales within a short span of time. Sales promotion techniques are being increasingly used by retailing organisations some of which include advertising, providing discounts and allowances or a 'buy one get one free offer' etc.

Higher Quality Scores typically result in lower costs and better ad positions. Quality Score is Google's rating of the quality and relevance of both your keywords and PPC ads. It is used to determine your cost per click (CPC) and multiplied by your maximum bid to determine your ad rank in the ad auction process.

Nationalized banks are also known as public sector banks where the government is responsible for the deposition of money in these banks while in a private bank money is deposited by the person who owns the bank.

They get stored in System Catalog Views sys.server_principals and sys.sql_logins.

TELNET is a client-server application that allows a user to log on to a remote machine, giving the user access to the remote system. TELNET is an abbreviation of terminal Network.