Questionnaire
В прошлом годе сотворил я опросник для быстрого тестирования программистов для двух проектов на PHP. Хотите проверить себя? Вопросы ерундовые.
Questionnaire
General knowledge
1. What is PHP? What are the differences between PHP 4 and PHP 5?
2. What is HTTP? What types of HTTP requests do you know?
3. What is SQL? What RDBMSes do you know?
4. What is web server? What web servers do you know?
5. What is the difference between HTML and XML? What markup languages do you know besides HTML and XML?
PHP
1. Do you need to initialize the variable before its usage? Why?
2. How do you use a function’s parameters inside the function?
3. There are two non-empty arrays $a and $b. What is the result of their sum (+)?
4. Comment the following code:
$q = ‘SELECT * FROM mytable WHERE id = ‘ . $_POST['id'] ? Is there any possibility to make it better?
5. How do you swap the values of string variables $a and $b, without using a third variable?
6. What way will you choose to sort the array of strings?
7. What methods can you use to start a PHP block? Which is best,and why?
8. What will be the value of $a after the execution of the following line of code:
$a = include ‘somefile.php’; ?
9. Describe the advantages and disadvantages of the various ways of configuring a Web server to process PHP scripts.
10. What are the sessions? How is sessions data stored at the server?
OOP in PHP5
1. What is an object?
2. What is a class?
3. What is an interface?
4. What is inheritance, and why do you need it?
5. What is the Hollywood principle?
6. What is coupling?
7. What is tight coupling, is it bad or good?
8. What are design patterns? What design patterns do you know, which of them do you use?
9. What is the difference between equations of objects $a == $b and $a === $b?
10. What is the garbage collector? Describe the disadvantages of the garbage collector in PHP earlier than 5.3?
Relational DBMSes
1. There is a table of two fields, primary key integer ID and char(50) VALUE. Before adding the unique index to it, you need to know, if there are duplicated VALUEs in the table. How you will do it?
2. What’s the difference between INNER JOIN and OUTER JOIN? What other types of JOINs do you know?
3. What is a VIEW? What are the advantages and disadvantages of views?
4. What’s the main difference between WHERE and HAVING?
5. What are subqueries? Does MySQL support them?
SVN
1. How to know who performed the last three commits to trunk?
2. What is the difference between cp and svn cp?
3. What does the -m key of the command svn commit?
4. Assume that we need to share the project with the developer-specific configuration file. How to avoid the conflicts between the developers if they’re modifying it?
5. What disadvantages have the HTTP protocol when you’re using it to access the storage?
Additional info
1. Which source control systems do you know? Which of them did you use?
2. What software do you use for PHP development?
3. What CMS/CMF do you know?
4. Do you have experience with bug tracking systems?
5. Do you know Unix?