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

All the above listed are debugging windows in .NET

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.

It is stored in the most significant bit. Bit is ON if -ve, OFF if +ve.

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.

Drop Ship refers to, a manufacturer shipping goods directly to one of its customers' customer (instead of delivering the goods to the customer that placed the order with the manufacturer).

This concept of shipping goods is called as drop ship, drop shipping or a drop shipment.

SELECT statement has resulted in retrieval of more than one row.

Read - Reads users input, parse the input into JavaScript data-structure and stores in memory

Eval - Evaluates the data structure

Print - Prints the result

Loop - Loops the above command until user press ctrl-c twice