Hari Kamis, 14 Desember 2006 saya mengirimkan surat lamaran untuk Lowongan Web Programmer (PHP), dan hari Jum’at 15 Desember 2006 sudah ada balasan lewat email dan disertai dengan attachment Interview Test. Dan ternyata saya masih harus belajar banyak . Emang bener tak ada manusia yang sempurna. emoticonBerikut PHP Programmer Interview Test nya :

PHP Programmer Interview Questions

  • Answer the questions brief and short in English (preferred) or Indonesian.
  • Write codes in PHP files, not on paper!
  • For walk-in test, use this MySQL configuration:
  • Server = 192.168.0.225, Username = test, Password = test, Database = test
  • Use http://192.168.0.225/phpmyadmin/ to administer the database.

General

  1. What books have you read about programming?
  2. What revision/version control systems do you use (eg. CVS, Microsoft SourceSafe, others)? Why do we need them?
  3. Give one reason why we need coding standards.
  4. What is “reusability”?
PHP
  1. What happens in a Web application when you enter all the data and click on submit button?
  2. What is the difference between GET and POST methods in form submitting?
  3. What do you like and dislike about PHP?
  4. What is the “condition" so that the following code snippet prints both HelloWorld!

    if (condition)

    print("Hello");

    else

    print("World");
  5. How to redirect to another page?
  6. Write a PHP function that tells me if its argument is a power of 2.
  7. Why is not recommended to rely on register globals and magic quotes?
  8. What is the difference between accessing a class method via -> and via ::?
  9. What is the purpose of “session”?
  10. What are the differences between public, private and protected in OOP?
  11. Create 3 new PHP classes for each real-world object that you found around you.

Database

  1. How can we find the number of rows in a table using MySQL?
  2. Rewrite this query using a subquery: SELECT DISTINCT t1.* FROM t1, t2 WHERE t1.id = t2.id
  3. What is the difference between GROUP BY and ORDER BY in SQL?
  4. What is the difference between a primary key and a unique key?
  5. What are MySQL transactions?
Develop a simple website using PHP & MySQL (pick one):
  1. Membership system. Create a registration page, login page, and when user has logged in, he/she can logging out by clicking a logout link. Store the user profile in database!
  2. Paginating system. Create a table with 25 or more rows, and then create a page which displays the table but only 5 items at a time. User that display the page can click on Next”, “Previous”, “Home” and “End” links to navigate through the table’s data.

PHP Interview Questions by Ivan Petrus (ivan@virtual-map.com)

Copyright © 2006 VMi Technologies