A company was looking to hire someone for an important position, so they interviewed dozens of applicants and narrowed their search down to three people.
In an attempt to pick one of them, they decided to give them all the same question to answer within 24 hours and the one with the best answer would get the job. The question was:
1. What programming language is GOOGLE developed in?
2. What is the expansion of YAHOO?
3. What is the expansion of ADIDAS?
4. Expansion of Star as in Star TV Network?
5. What is expansion of "ICICI?"
6. What does "baker's dozen" signify?
7. The 1984-85 season. 2nd ODI between India and Pakistan at Sialkot - India 210/3 with
Vengsarkar 94*. Match abandoned. Why?
If we were to Honestly reply to all the HR Questions they would go something like this
1. Why did you apply for this job?
I have applied for many jobs along with this and you called me now.
2. Why do you want to work for this company?
I have to work for some company who ever gives me a job, I don't have any specific company in mind.
3. Why should I hire you?
Question 1: You are driving along in your car on a wild, stormy night, it's raining heavily, when suddenly you pass by a bus stop, and you see three people waiting for a bus:
An old lady who looks as if she is about to die.
An old friend who once saved your life.
The perfect partner you have been dreaming about.
How Much Do You Want It to Be?
A company founder needed to choose his successor. He studied resumes and talked to references, but he asked only one question during the final interview: "How much is 2 + 2 ?"
Ann, the first candidate, worried that there was a trick but answered straightforwardly.
"There’s only one correct answer: four.
Q. How can you drop a raw egg onto a concrete floor without cracking it?
A. Concrete floors are very hard to crack!
Q. If it took ten hours for eight men to build a wall, how long would it take four men to build it?
A. No time at all it is already built.
Q. Approximately how many birthdays does the average Japanese woman have?
A. Just one. All the others are anniversaries.
1.What are the differences between a OLAP and OLTP applications
OLAP
a.Summarized data
b.Read only
c.Not Optimized
d.Lot of historical data
OLTP
Detailed
Read write
Optimized for data applications
Not much old data
2.What is a star schema?
A fact table at the center and surrounded (linked) by dimension tables
3.What is a slowly changing dimension?
Below are some behavioral interview techniques that you'll find useful:
1. Be prepared for the interview by analyzing and making an educated guess as to which skills are most desired by the employer. You can study the job description of the position or go to some job boards to review requirement sections of related jobs.
2. Compile a list of skills that are relevant to the position you are applying.
3. Identify behavioral interview questions by introductory phases like "Tell me about a time when...," " Describe a situation where you...," "Give me an example of..." etc.
Give the two types of tables involved in producing a star schema and the type of data they hold.
Answer :
Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.
What are types of Facts?
Answer :
There are three types of facts:
1. How did you find me?
2. Is this a retainer or contingency assignment?
3. Are you dealing with the client’s HR people, or do you have direct contact with the hiring manager?
4. How long has the client been with you?
5. How many candidates have you placed with this client?
6. When will I find out the name of the principal or client company?