Re: How do you conduct technical interviews ?
Date: Thu, 14 Aug 2008 16:52:21 -0400
Oracle wasn't mentioned in the original question. And as you have said default transaction isolation level is different from database to database. Person with Sybase background might answer yes, but that doesn't mean he is bad.
On 8/14/08, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:
> I expect them to understand that Oracle does not do dirty reads (unlike,
> DB2 or SQL Server by default). That user a will not see user b's changes
> until user b commits said changes. I'd expect them to describe the purpose
> of UNDO as a part of this process.
> I'd like to know how you think the answer to this could be wrong answers in
> general? Dirty reads do not exist in Oracle, period.
> Robert G. Freeman
> Oracle Database 11g New Features (Oracle Press)
> Portable DBA: Oracle (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Oracle9i RMAN Backup and Recovery (Oracle Press)
> Oracle9i New Feature
> Blog: http://robertgfreeman.blogspot.com (Oracle Press)
> The LDS Church is looking for DBA's. You must be LDS to apply (please don't
> write to me and tell me I'm breaking the law. A church can choose to hire
> members of it's own faith. Look it up if you don't believe me).