Nick Halstead on his blog posts a list of interview questions from Yahoo! that a friend of his supplied, apparently free of NDA. Yahoo! is a strong PHP shop, with a few big names like Rasmus Lerdorf leading PHP development there.
A few questions on PHP functions, and “what does this code do?” type of questions that seem a bit off-the-mark in PHP environment, with naming consistency like array_pop and shuffle (both do operations on array), and frequent swaps in the order of parameters passed in. Some fairly good questions, though:
How do you debug a PHP application? - Interesting to see what the interviewee used outside of echo’s and error_log’s.
Is PHP better than Perl? Discuss. and before that What’s the difference between the way PHP and Perl distinguish between arrays and hashes? - not sure how that relates to someone who’ve been using PHP all around, but occasionally played around with Perl, or vice versa, but nevertheless some good starting points for discussion.
By admin | March 21, 2008
Adam and Bob have exact speeds for walking and running - neither Adam outwalks Bob, nor Bob outruns Adam.
But for a given distance, Adam runs half the time, then walks another half. Bob runs half the distance, then walks another half.
If they were to compete, which distance would Adam win at, and which distances would Bob be the winner at?
Posted in General, Puzzles |
By admin | December 29, 2007
Jay Pipes, author of Pro MySQL, on his blog posts 10 questions and answers dealing with MySQL speed optimizations.
- Which will be faster out of these two queries - one with OR or one with IN?
- Where does MyISAM cache table records?
- Which will be faster out of queries with explicit INNER JOIN and implicit one?
- Is InnoDB faster/better than MyISAM?
- Is CHAR faster than VARCHAR?
- Is VARCHAR(80) faster than VARCHAR(255)?
- Are there performance issues when joining tables from different storage engines?
- If I change a derived table to a view, will performance increase?
- If I see Using temporary; Using filesort” in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?
- Is it possible to do a FULL OUTER JOIN in MySQL?
By admin | December 28, 2007
Some would say that a position of a search engine marketer or optimizer is not a very technical one. True, compared to Linux kernel hacker, the technical knowledge required for entering SEO field seems simpler, but when the site is built and serving pages, you’re very likely to have SEO go over the site structure and reprogram essential parts of it. Anyway, check out 55 search engine optimization questions, and either test yourself, or use them whenever you’re interested in hiring a search engine marketer.
Posted in General, Web dev |
By admin | December 11, 2007
These questions were sent in from IBM. They discuss various telecom and networking topics.
- OSPF
- Describe OSPF in your own words.
- OSPF areas, the purpose of having each of them
- Types of OSPF LSA, the purpose of each LSA type
- What exact LSA type you can see in different areas
- How OSPF establishes neighboor relation, what the stages are
- If OSPF router is stucked in each stage what the problem is and how to troubleshoot it
- OSPF hierarchy in the single or multi areas. Cool OSPF behavior in broadcast and nonbroadcast
- Draw the diagram of typical OSPF network and explain generally how it works, DR, BDR, election, ASBR, ABR, route redistribution and summarization
Read More »
By admin | December 7, 2007
A TechInterviews reader sent in the questions he faced at a major global company. The questions are fairly generic:
- Tell me about your analytical skills, cite some examples of how you have used your skills in the past.
- What are some of your long term goals?
- What are your short term goals?
- Where do you see yourself five years from now?
- Tell me why I should hire you?
- What does customer service mean to you?
- Why did you leave your last job?
- Describe your definition of a team player?
- Sight examples of when in the past you have proven to be a team player?
- How would you handle a conflict with another employee?
- What do you believe you can gain by working at this company?
- Give me some examples of times in the past, when you were able to avoid a conflict, by thinking on your feet. Tell what you know about this company.