1. What is an associative array? Write a brief example.

2. What is a multidimensional array? Write a brief example.

3. What is a multidimensional associative array? Write a brief example.

4. If you had to parse a CSV file that exceeded PHP's memory limit, without changing the memory limit in the PHP ini file, how would you parse the file? Write pseudo code as an example to show a proof.

5. Name three things you try to avoid when designing a database schema.

6. If you had to store an image in a database table for output on a dynamic template, how would you store it?

7. Write a brief description of how you would design a database schema to store daily impression hits.

8. What is the term used for encapsulating data within a query string during an HTTP request? Which PHP functions would you use to encapsulate this data?

9. What is a design pattern? Can you give one common PHP design pattern as an example?

10. What is a test pattern? Can you give an example of a test pattern you used in the past?

11. What is the difference between a char field and a varchar field in mySQL?

12. What is SQL injection?

13. How can you prevent SQL injection?

14. What is the difference between an Abstract class and an Interface?

15. What is an MVC framework? Briefly describe that advantages of using an MVC framework method.

16. With the following SQL statement in a table that has 300,000 records, which fields do you believe should be indexed?

"SELECT * from USERS where username='foo' and pass='bar' and active='yes' and priv='5'"

17. What is a mySQL Trigger? Give one example where you would use a trigger in a real world scenario.

18. What is the EXPLAIN function in mySQL used for?

19. What is database normalization?

20. In a multi web server environment, how would you alter PHP's default session handling to ensure that the user is able to reinitiate the same data using their existing cookie session id?

21. How would you store an array of user session data into one database field?

22. What is JSON? Give a brief example of when you would use JSON.

23. What is a UUID/GUID? What is the advantage of using one over an ordinal id field?

24. How can you debug a system in a production environment, while it is being used, without adversely affecting the user experience?

25. What is important when updating a product that is in production and being used?

26. What is recursion? Give a simple example of a recursive function.

27. What are some of the most important tools you use working on a normal day to day basis? Name as many as you like.

28. How would you change the format of all the phone numbers in 10,000 different HTML pages?

29. What is the difference between procedural programming and object oriented programming?

30. How can you reduce the users perception of waiting when a function takes a long time?

31. Name the two most general/common types of load balancing.

32. Name some of the biggest differences between the mySQL myISAM table engine and the InnoDB table engine?

33. When writing an impression logging database schema, what table engine would you use, and why?

34. When writing a transaction processing database schema, what table engine would you use, and why?

35. What is an MTA? Name three commonly known ones.

36. When would you use a delayed insert? What table engines support delayed inserts?

37. What is the advantage to having fewer indexes on a table?

38. Name some things you commonly do to optimize your database architecture and it's queries.

39. Name some ways you commonly debug your code on a day to day basis.

40. What are some important monitoring tools you like to use to determine the overall health of a software project?