This is the solution for Oracle Challenge #3. If you haven’t read the challenge, go and check it before you read the solution here.
I debated quite a lot before writing this post. When I wrote the post about interviewing a DBA, in the “technical questions I do ask” part I just gave a general explanation of what I ask, but didn’t reveal the real questions. Now, more than 3 years later, I decided to give one of the questions as a challenge here.
I posted my first challenge almost 2 years ago and there was a lot of interest in it. Today I post another one.
Many years ago I saw this strange thing and it took me some time to realize what’s going on. Since then I ran into this scenario a few times, solving it instantly (and make a good impression at the same time).
Today I ran into a strange Oracle situation. It took me some time to realize what it is, so I decided to write it as a challenge. Hope you will find it interesting.
I have 2 tables, A and B. Each table has indexes, constraints, many columns and more (But no triggers). Table A has the ID column (which is the primary key) and the NAME column (varchar2). Table B has the ID column (primary key) and the A_ID column (which is FK to table A). Continue reading “Oracle Challenge”