We just held the 6th quarterly championship playoff at the PL/SQL Challenge. 34 players competed, answering five tough quizzes.It takes a lot to qualify for the playoff: you must rank in the top 25 over the entire quarter (and some 60 quizzes); your percentage correct must be very high; or you are selected in a wildcard process that still requires a high level of play.
You will find the results and rankings below. Congratulations to all players, of course, but let's give a special round of applause to our top three players:
You will find below the results of the Q2 2011 championship playoff. You can take a look at the quizzes that were in the competition through the Library page. These results will also be available through the Rankings page.
Congratulations to all players, of course, but let's give a special round of applause to our top three players:
The Q2 2011 playoff tested players' knowledge of Oracle's compile-time warnings, in particular some key warnings added in Oracle Database 11g Release 2. In this quiz, we showed a program unit and asked how many warnings would be displayed by Oracle.
Players had the following objections:
In the Q2 2011 playoff, one of the questions examined the nuances of using BULK COLLECT and FORALL to optimize one's code. We asked players "Which of the statements below describe a complete or partial step towards improving the performance of this program, while keeping intact all current functionality?"
And we scored as incorrect this choice:
For those of you who have not yet started visiting the PL/SQL Challenge website regularly, I thought I'd offer this guide to recent quizzes.
In the past week (11 July - 16 July), 972 Oracle technologists were busy answering quizzes and exploring the library of past quizzes.
In the logic puzzle for the week of 9 July, we scored the following choice as correct:
The explanation given was this: "If 1 is in the solution, then the third turn tells us that (3, 6, 5) cannot be in the solution. The only 3 numbers left are (2, 4, 7) and looking over the first two turns, they would be compatible. So the four numbers (1, 2, 4, 7) could be in the solution together."
The SQL quiz on PIVOT for the week of 9 July asked which of the choices produce this desired output:
DEPARTMENT_ID LESS MORE ------------- ---------- ---------- 100 2 0 200 2 1
And we scored a choice as incorrect simply because the column headers would not match what is shown above. Specifically, the headers would be:
DEPARTMENT_ID 'LESS' 'MORE'
A player raised a concern about this as follows: