What are some interview questions to ask candidates for a web 2.0 technologies (PHP, AJAX, LINUX, MYSQL)

             I think in interviews, mostly the recruiter will give U a situation or his requirement. And he'll see how U R thinkin' & how simple your ideas & answers are to fulfill his requirement. Geeks thinks like that. Even though for formality they fires basic Questions like pasted below. 

MSSQL (www.techinterviews.com)

1. Explain MySQL architecture. - The front layer takes care of network connections and security authentications, the middle layer does the SQL query parsing, and then the query is handled off to the storage engine. A storage engine could be either a default one supplied with MySQL (MyISAM) or a commercial one supplied by a third-party vendor (ScaleDB, InnoDB, etc.)
2. Explain MySQL locks. - Table-level locks allow the user to lock the entire table, page-level locks allow locking of certain portions of the tables (those portions are referred to as tables), row-level locks are the most granular and allow locking of specific rows.
3. Explain multi-version concurrency control in MySQL. - Each row has two additional columns associated with it - creation time and deletion time, but instead of storing timestamps, MySQL stores version numbers.
   
4. What are MySQL transactions? - A set of instructions/queries that should be executed or rolled back as a single atomic unit.

PHP (www.techinterviews.com)

1. What are the differences between Get and post methods in form submitting, give the case where we can use get and we can use post methods?
2. Who is the father of PHP and explain the changes in PHP versions?
3. How can we submit a form without a submit button?
4. In how many ways we can retrieve the date in the result set of mysql using PHP?
5. What is the difference between mysql_fetch_object and mysql_fetch_array?

AJAX (www.geekinterview.com)

1.  what is AJAX ? How it is implemented? Given skeleton example?  
2.  What is the back ground work going on when you type www.yahoo.com in your web browser?  
3.  What is the difference between DOM Parser and AUX Parser?  

4.  Who is the inventor of AJAX?  

5.  What are the different frameworks available In AJAX?  

6.  What AJAX framework do you recommend for PHP applications?  

LINUX (www.techinterviews.com)

1. Advantages/disadvantages of script vs compiled program.
2. Name a replacement for PHP/Perl/MySQL/Linux/Apache and show main differences.
   
3. Why have you choosen such a combination of products?
4. Differences between two last MySQL versions. Which one would you choose and when/why?
5. Main differences between Apache 1.x and 2.x. Why is 2.x not so popular? Which one would you choose and when/why?
6. Which Linux distros do you have experience with?
7. Which distro you prefer? Why?
8. Which tool would you use to update Debian / Slackware / RedHat / Mandrake / SuSE ?
9. You’re asked to write an Apache module. What would you do?
10. Which tool do you prefer for Apache log reports?  

Hope U got it. And don' know that U R going to take an Interview or to attend.