Oracle Challenge #3 – SQL

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.

Continue reading “Oracle Challenge #3 – SQL”

Oracle Challenge #2

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).

Continue reading “Oracle Challenge #2”

Oracle Challenge

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”