Interview Questions

A 32 bit processor is faster than a 64 bit processor, 64 bit processors are very commonly used that you can find it easily in any home pc but the main difference is the hardware you are having on your machine. For 32 bits there isn't any need of any wide main bus to carry 32 bits at a time but for 64 bits its must that you should have a wider bus to carry 64bits.

•  NO_CACHE – It is used for not caching values.


•  PRE_LOAD_CACHE – Result column preloads and compares the column into the memory, prior to executing the lookup.


•  PRE_LOAD_CACHE is used when the table can exactly fit in the memory space.


•  DEMAND_LOAD_CACHE – Result column loads and compares the column into the memory when a function performs the execution.


•  DEMAND_LOAD_CACHE is suitable while looking up the highly repetitive values with small subset of data.

Look for the existence of the following items:

- Generic Data Models

- An Enterprise Data Platform

- Identify the Data Sources

- Selection of a MDM Product

- Implementation of a Customer Master Index or appropriate alternative

Htmlentities() converts all applicable characters to HTML entities. While htmlspecialcharacter()converts special characters to HTML entities. This means htmlentities( ) will check for non English language characters, such as French accents, the German umlaut, etc.

$_SERVER and $_ENV arrays contain different information. The information depends on the server and operating system being used. Most of the information can be seen of an array for a particular server and operating system. The syntax is as follows:

foreach($_SERVER as $key =>$value)

{ echo “Key=$key, Value=$value\n”; }

The purpose of this question is to check your adaptability and flexibility. Did you feel victimized?

Answer this question by mentioning the change that was made but the main focus should be on how you adjusted in that situation and the results you achieved afterwards.

For example you can say something like, “Being an early joiner in the marketing team, I opened a lot of new customer accounts. Over the time the team grew and we had more people in the team opening more accounts. At one point of time, we had to re-distribute the accounts area wise so that a particular territory can be allotted to each one of us. This re-distribution meant loss of my high performing accounts and a requirement to develop new accounts in the assigned territory. Initially, it looked difficult but I could understand the need for this re-distribution and saw more opportunities for the company and myself. I introduced my colleagues to the old accounts I held and started strategizing for better ways to tap the new territory. Within 6 months, I could develop 50 new accounts with the help of new strategy. Usually we would achieve this result in 9 months to a year.”

Change management is the biggest challenge in each and every industry. After requirements stage when development is started client will come-up with some new changes or enhancements. 

Cross departmental or cross team management – like conflict management between teams. Also individuals. This requires soft skills and smartness. 

Communication problems – In real time this can happen. You might be good in speaking and understanding the English language. BUT sometimes it happens like Different people across the globe speak different style of English. In USA itself Mexico people speak English differently. Romans speak different English. So at initial level to understand the accent can be a challenge but after some time you will become perfect. 

URI is known as Uniform Resource Identifier as it identifies the resources requested by clients and fetches them from the server. 

The components that are used in URI are as follows:

- http: is the first thing that is used in a URL and it is used to tell what kind of resource that needs to be retrieved over the server.

 This includes the server details and it is itself a protocol known as Hypertext Transfer Protocol (HTTP) that is used to fetch the information. 

- Web browsers sometimes use the secure protocol that is represented using HTTPs used in case of secure transaction over the internet. 

- FTP: is also a protocol that is known as File Transfer Protocol that allows the transfer from a file from local computer to server