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

How do you handle stress?

Wrong approach -
Do not say you are never under stress or I hate stress or you do exercise and meditation to take care of stress. Focus strictly on professional things that you do.

Right approach -
A good response is to say that pressure helps you focus and maintain your drive and like to handle challenges. Explain that some of your best efforts are the result of stress and pressure. Also inform that when pressure gets too intense, you know how to handle it.

Example -
Stress and pressure are a challenging part of the job and i know how to handle it. I handle it by focusing on proper planning and reporting, better time management, open communication, Hard work and prioritization.

Dim obj as OBJ.CLASS with eitherSet obj = New OBJ.CLASS orSet obj = CreateObject(OBJ.CLASS?) orSet obj = GetObject( , OBJ.CLASS?)orDim obj as New OBJ.CLASS 

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.

a.Understanding the customer profile : the tastes,preferences, habits of the customers may differ from person to person.

b.Determining the objective as to who would be the target market, whether the company wants to go for cost minimisation or not etc.

c.Type of channel members :Who all would be involved? Wholesalers, retailers?

d.The criteria on which the channel members would be evaluated and selected.

e.How many intermediaries will be involved in the overall distribution?

The purpose of garbage collection is to identify and discard those objects that are no longer needed by the application, in order for the resources to be reclaimed and reused.

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.