Re: Interview questions?
On 12/18/06, Peter Smith <[EMAIL PROTECTED]> wrote: Hello MySQLers, Since I'm mildly technical and I know how to spell orakle, I've been asked to write up some technical interview questions for a MySQL position at a startup. Can any of you help me out? Your apparent focus on doing what is best for the company will rob you of the opportunity to have fun. You need to include at least one question that the interview candidate has no reasonable hope of answering, just for your own amusement. How about: How do applications of the latin1_german1_ci and latin1_german2_ci collation differ? Why and how are dictionary sort order and phone book sort order in the German language different? Dave.
Re: Interview questions?
Well, The hiring mgr told me that he is looking for an Oracle DBA who also knows MySQL. To me that is a short sentence but says a lot since the term Oracle DBA is kind of a loaded term. Generally it someone with a large DB/data center kind of a slant. Less of a programmer and more of an operations person. A good Oracle DBA is usually good at performance tuning large hairy sql statements. Also a good Oracle DBA knows quite a bit about UNIX sysadmin stuff and storage admin stuff. Generally an Oracle DBA is weak when dealing with web servers and php compared to a lot of strong MySQL techies. That add any substance to my question? On 12/18/06, Chris White <[EMAIL PROTECTED]> wrote: On Monday 18 December 2006 18:23, Peter Smith wrote: > Hello MySQLers, > > Since I'm mildly technical and I know how to spell orakle, > I've been asked to write up some technical interview questions > for a MySQL position at a startup. > > Can any of you help me out? > > I did some searching via google and did not find anything all that > good. Depends what you're looking for in your candidates. There are the "Do you know how to program applications that use a database" types and "Describe the 3 main levels of normalization" types and "You go to create a foreign key constraint on an InnoDb table and it fails, what things should you look for to solve the issue?" types. That's why it's really hard to find anything like that on google. The best thing to do would be describe what exactly this person will be doing. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Peter Smith [EMAIL PROTECTED] http://GoodJobFastCar.com
Re: Interview questions?
On Monday 18 December 2006 18:23, Peter Smith wrote: > Hello MySQLers, > > Since I'm mildly technical and I know how to spell orakle, > I've been asked to write up some technical interview questions > for a MySQL position at a startup. > > Can any of you help me out? > > I did some searching via google and did not find anything all that > good. Depends what you're looking for in your candidates. There are the "Do you know how to program applications that use a database" types and "Describe the 3 main levels of normalization" types and "You go to create a foreign key constraint on an InnoDb table and it fails, what things should you look for to solve the issue?" types. That's why it's really hard to find anything like that on google. The best thing to do would be describe what exactly this person will be doing. -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Interview questions?
Hello MySQLers, Since I'm mildly technical and I know how to spell orakle, I've been asked to write up some technical interview questions for a MySQL position at a startup. Can any of you help me out? I did some searching via google and did not find anything all that good. I'm tempted to just go here: http://dev.mysql.com/doc/refman/5.1/en/ix01.html And make up some of my own questions. Here's one: What is mysqlcheck? When would I use it? Here's another: CHECK TABLE What is it? I searched for MySQL mail lists. I only found 1 which looks significant: mysql@lists.mysql.com Are there others well suited for newbs? ...Peter -- Peter Smith [EMAIL PROTECTED] http://GoodJobFastCar.com