RE: JAVA Developer
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Laimutis.Nedzinskas@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 Jan 2007 16:12:18 -0500
The ask some more advanced questions like what he thinks how rdbms finds one
particular row out of 100T rows? Does he suspect that "where like '%java%'" can
be tricky? May be he even has an idea how rdbms can order rows? May be he
suspects that condition (b=1 or a=2) can be a culprit?
Can you elaborate on this? 'tricky', 'culprit condition'
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Laimutis Nedzinskas
Sent: Monday, January 08, 2007 11:50 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: JAVA Developer
Ask if he has heard about strong typing. Is he going to use strings for dates?
Does he actualy know there is a date datatype in most of rdbms'es ? Does he
suspect that date may be a datetime in some of them? Is he going to rely on
implicit conversion or he already knows there is a function to convert string
to/from date ? May be he even knows that format mask can be explicitely
specified ?
Ask if he has heard about bind variables to start with. Then ask how he is
going to implement them. Ask to show (pseudo)code samples.
The ask some more advanced questions like what he thinks how rdbms finds one
particular row out of 100T rows? Does he suspect that "where like '%java%'" can
be tricky? May be he even has an idea how rdbms can order rows? May be he
suspects that condition (b=1 or a=2) can be a culprit?
May be he has some idea that statement.execute means some network roundtrips to
the server?
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joel.Patterson@xxxxxxxxxxx
Sent: 8. janúar 2007 16:36
To: oracle-l@xxxxxxxxxxxxx
Subject: JAVA Developer
We are getting ready to hire a JAVA Developer, and I was asked if I wanted to
ask some questions relating to the database.... or to see if we get along.
Connection pooling comes to mind, not imbedding code that would become a cpu
issue, etc.
Not having much experience with Java, do anyone have questions I could
entertain? Some of you may have had such an experience already, and could pass
on a couple questions you wish you had asked, or would ask next time.
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer <http://www.landsbanki.is/disclaimer>
Other related posts:
