Interview Questions

By the use of void set_time_limit(int seconds)

Set the number of seconds a script is allowed to run. If this is reached, the script returns a fatal error. The default limit is 30 seconds or, if it exists, the max_execution_time value defined in the php.ini. If seconds is set to zero, no time limit is imposed.

When called, set_time_limit() restarts the timeout counter from zero. In other words, if the timeout is the default 30 seconds, and 25 seconds into script execution a call such as set_time_limit(20) is made, the script will run for a total of 45 seconds before timing out.

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

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.

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

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.

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.

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.