Job interview sample tests

Create online test to evaluate the candidate skills before interview: http://www.classmarker.com

PHP developer

1.what are the differences between echo and print?
2.Types of MySQL connection?
3.Handling regular expression?
4.Date format?
5.Mail function?
6.xml handling?
7.What is class, polymorphism, inheritance, constructor, object?
8.Date format?
9. Who is the creator of PHP?

See http://www.scribd.com/doc/5008379/PHP-Developer-Interview-Questions-Answers

Sysadmin (LAMP environment)

Question: In MySQL, which command should I use if I want to list all MySQL processes in progress.
Answer: show processlist

Q: Which command should I use to add an index in a MySQL table?
A: alter table X add index (y)

Q: How can I know if an Index is present on a mysql field?
A:
- show create table X
- describe X

Q: Say 3 SMTP commands.
A:
- HELO
- VRFY
- MAIL FROM
- RCPT
- DATA
- QUIT

Q: How can I check if the domain name foo.com is not expired?
A: whois foo.com

Q: How can I identify the nameservers of the domain name foo.com in command line ?
A:
- dig foo.com NS
- host -t ns foo.com- ns foo.com

Q: How can I see all the files opened by a process?
A:
- lsof
- ls -l /proc/PID/fd

Q: How can I edit the cron jobs of user john ?
A: crontab -u john -e

Q: How can I see all the apache request in progress on a server?
R: display URL http://server/server-status

Q: How can I see the content of this URL http://site.com/page with Telnet ?
A:
telnet site.com 80
GET /page HTTP/1.0
Host: site.com

Q: A MySQL request takes more than 5 minutes, What do I need to check?
A:
- check indexes
- check other requests in progress
- check if other MySQL process use CPU/RAM/disk resources
- MySQL commands:
- show processlist
- show create table X
- alter table X add index (y)

Q: An user can send an email. What do I need to check?
A:
- ask user the exact error message, connection time, email address sources and destination.
- check server logs
- check client parameters (server, pass...)
- check with client parameters
- inactive client anti virus

Q: A webpage in a LAMP environement takes more than 30 secondes to display. What do I need to check?
A:
- check server logs
- check where the script is stuck (CPU, SQL, distant connection...)