26 March 2015

Tweaking the Weekly Quizzes at the PL/SQL Challenge

We've decided a couple of things:
  1. Enough with the really dull names as in "Weekly SQL Quiz".
  2. It's time to start up Deja Vu quizzes for SQL, Database Design, and Logic.
So starting on 4 April 2015 (just shy of the fifth anniversary of the PL/SQL Challenge)....

SQL Quizzes

We will rename and continue the weekly SQL quiz as Select from SQL.

And we will add a Deja Vu SQL quiz.

Database Design Quizzes

The weekly Database Design quiz will be renamed to Dynamite DB Design, but otherwise continue unchanged.

And we will add a Deja Vu DB Design quiz.

Logic Quizzes

The weekly Logic quiz will be renamed to I Love Logic, and will free itself from the constraints of our Mastermind-style quiz and offer various formats of logic puzzlers.

And we will add a Deja Vu Logic quiz.

Annual Championships

For 2015 and beyond, the rankings of all competitive quizzes (Oracle Magazine and Deja Vu quizzes are, for example, not competitive) in a domain will be combined to determine eligibility in the annual championships.

16 March 2015

Results of 2014 PL/SQL Championship

You will find below the rankings for the 2014 PL/SQL Championship; the number next to the player's name is the number of times that player has participated in a championship (you will see "1" for all players, since this was the first annual PL/SQL championship).

Congratulations first and foremost to our top-ranked players:

1st Place: mentzel.iudith of Israel

2nd Place: Andrey Zaytsev of Russia

3rd Place: _tiki_4_ of Germany


Next, congratulations to everyone who played in the championship. I hope you found it entertaining, challenging and educational. And for those who were not able to participate in the championship, you can take the quizzes next week through the Practice feature. We will also make the championship as a whole available as a Test, so you can take it just like these players did.

Finally, a big thanks to our reviewers, especially Elic, who not only reviewed three quizzes but also wrote two - a tremendous help for a busy Oracle Developer Advocate for PL/SQL (that is, me).

Steven Feuerstein

Rank Name Country Total Time % Correct Total Score
1mentzel.iudith (1)Israel32 mins 37 secs88%7520
2Andrey Zaytsev (1)Russia34 mins 50 secs84%7211
3_tiki_4_ (1)Germany22 mins 00 secs83%7112
4Karel Prech (1)Czech Republic33 mins 25 secs83%7066
5Ravshan Abbasov (1)Uzbekistan29 mins 50 secs81%6931
6VictorD (1)Russia30 mins 20 secs81%6929
7Jeroen Rutte (1)Netherlands34 mins 52 secs81%6911
8João Barreto (1)Portugal24 mins 07 secs79%6804
9Pavel Noga (1)Czech Republic33 mins 56 secs78%6614
10Michal Cvan (1)Slovakia34 mins 23 secs78%6612
11dmitrysk (1)Russia31 mins 41 secs76%6473
12Kuvardin Evgeniy (1)Russia34 mins 22 secs76%6463
13Chad Lee (1)United States25 mins 14 secs74%6349
14Viacheslav Stepanov (1)Russia33 mins 58 secs74%6314
15Siim Kask (1)Estonia33 mins 59 secs74%6314
16Ivan Blanarik (1)Slovakia31 mins 13 secs72%6175
17Marcus Matzberger (1)Germany27 mins 44 secs71%6039
18Rytis Budreika (1)Lithuania16 mins 42 secs69%5933
19gobruins (1)United States23 mins 35 secs69%5906
20Christoph Hillinger (1)Austria28 mins 51 secs69%5885
21Niels Hecker (1)Germany30 mins 28 secs69%5878
22Patrick Barel (1)Netherlands20 mins 23 secs67%5768
23swart260 (1)Netherlands32 mins 36 secs67%5720
24Jan Šerák (1)Czech Republic33 mins 08 secs67%5717
25Chase Mei (1)Canada34 mins 26 secs67%5712
26Joaquin Gonzalez (1)Spain17 mins 40 secs66%5629
27Ingimundur Gudmundsson (1)Norway33 mins 18 secs66%5567
28Martin_Scholz_Berlin_München (1)Germany34 mins 31 secs64%5412
29Krzysztof Helbin (1)Poland14 mins 10 secs62%5343
30Rakesh Dadhich (1)India18 mins 53 secs62%5324
31Leszek Grudzień (1)Poland24 mins 59 secs62%5300
32tonyC (1)United Kingdom32 mins 23 secs62%5270
33Henry Abeska (1)Czech Republic22 mins 26 secs55%4710
34Alex Stirbu (1)Romania23 mins 47 secs55%4705
35Sean Molloy (1)United States31 mins 56 secs55%4672
36Manfred Kleander (1)Austria34 mins 28 secs55%4662
37Pavel Vorontsov (1)Russia11 mins 29 secs53%4604
38Stelios Vlasopoulos (1)Belgium24 mins 22 secs50%4253
39Jerry Bull (1)United States02 mins 45 secs10%889

03 March 2015

Results of 2014 Annual Logic Championship


You will find below the rankings for the 2014 Logic Championship; the number next to the player's name is the number of times that player has participated in a championship.

Congratulations first and foremost to our top-ranked players:

1st Place: Mehrab of United Kingdom - 100% correct!

2nd Place: Christoph Hillinger of Austria
 - 98% correct!

3rd Place: Rytis Budreika of Lithuania
 - 98% correct!
Next, congratulations to everyone who played in the championship. I hope you found it entertaining, challenging and educational. And for those who were not able to participate in the championship, you can take the quizzes next week through the Practice feature. We will also make the championship as a whole available as a Test, so you can take it just like these players did.

This championship marks a big change for the Logic quizzes. For several years we have used a Mastermind-like format for our quizzes. Yet we also published (and, of course, anyone could also write) automated solvers for Mastermind.

As a result, we changed our quizzes for the championship and expect to do so for the weekly quizzes as well.

Steven Feuerstein

PS - Below the table of results for this championship, you will find another list showing the championship history of each of these players.

Rank Name Country Total Time % Correct Total Score
1Mehrab (2)United Kingdom44 mins 28 secs100%4159
2Christoph Hillinger (2)Austria32 mins 22 secs98%4086
3Rytis Budreika (2)Lithuania38 mins 16 secs98%4069
4gobruins (2)United States26 mins 29 secs95%3996
5Viacheslav Stepanov (2)Russia44 mins 03 secs95%3946
6Rich Dellheim (2)United States39 mins 57 secs93%3850
7Pavel Zeman (1)Czech Republic43 mins 42 secs93%3839
8craig.mcfarlane (1)Norway44 mins 13 secs93%3838
9Naresh Kumar (2)Malaysia44 mins 53 secs93%3836
10Hamid Talebian (1)Netherlands38 mins 58 secs90%3746
11Elic (2)Belarus42 mins 45 secs90%3735
12JasonC (2)United Kingdom35 mins 05 secs85%3543
13katuinbouter (2)Netherlands42 mins 48 secs85%3521
14NickL (1)United Kingdom43 mins 18 secs85%3519
15Jerry Bull (2)United States44 mins 06 secs83%3410
16danad (2)Czech Republic44 mins 46 secs83%3408
17Kuvardin Evgeniy (1)Russia44 mins 07 secs80%3303
18mentzel.iudith (2)Israel43 mins 45 secs78%3196
19Sandra99 (2)Italy44 mins 34 secs78%3194
20Telmoc (1)Portugal40 mins 18 secs65%2671
21Niels Hecker (2)Germany43 mins 35 secs65%2661
22Eric Levin (1)United States44 mins 54 secs65%2657
23Krzysztof Helbin (1)Poland29 mins 45 secs63%2594
24Alex Stirbu (1)Romania44 mins 02 secs63%2553
25Köteles Zsolt (1)Hungary44 mins 07 secs63%2553
26Sean Molloy (2)United States44 mins 32 secs63%2551
27Justin Cave (2)United States40 mins 46 secs60%2455
28tommyTT (1)Poland41 mins 40 secs60%2452
29Stelios Vlasopoulos (2)Belgium43 mins 45 secs60%2446
30MarkM. (2)Germany44 mins 42 secs60%2444
31Chad Lee (2)United States44 mins 13 secs58%2338
32Zoran Krekic (1)Croatia24 mins 52 secs55%2286
33Jason H (2)United States37 mins 07 secs50%2037
34Oleksiy Varchyn (1)Norway17 mins 01 secs48%1987
36Henry Abeska (1)Czech Republic25 mins 19 secs38%1535
37Cor van Berkel (1)Netherlands10 mins 48 secs25%1041
38AndreyBerliner (1)Ukraine19 mins 26 secs23%909

Championship Performance History

After each name, the quarter in which he or she played, and the ranking in that championship.
Name History
Mehrab2013:30th, 2014:1st
Christoph Hillinger2013:18th, 2014:2nd
Rytis Budreika2013:12th, 2014:3rd
gobruins2014:4th
Viacheslav Stepanov2013:1st, 2014:5th
Rich Dellheim2013:31st, 2014:6th
Pavel Zeman2014:7th
craig.mcfarlane2014:8th
Naresh Kumar2014:9th
Hamid Talebian2014:10th
Elic2013:13th, 2014:11th
JasonC2013:35th, 2014:12th
katuinbouter2013:21st, 2014:13th
NickL2014:14th
Jerry Bull2013:2nd, 2014:15th
danad2013:23rd, 2014:16th
Kuvardin Evgeniy2014:17th
mentzel.iudith2013:4th, 2014:18th
Sandra992013:17th, 2014:19th
Telmoc2014:20th
Niels Hecker2013:3rd, 2014:21st
Eric Levin2014:22nd
Krzysztof Helbin2014:23rd
Alex Stirbu2014:24th
Köteles Zsolt2014:25th
Sean Molloy2013:24th, 2014:26th
Justin Cave2014:27th
tommyTT2014:28th
Stelios Vlasopoulos2013:16th, 2014:29th
MarkM.2013:10th, 2014:30th
Chad Lee2013:34th, 2014:31st
Zoran Krekic2014:32nd
Jason H2013:14th, 2014:33rd
Oleksiy Varchyn2014:34th
PLCHTEST2014:35th
Henry Abeska2014:36th
Cor van Berkel2014:37th
AndreyBerliner2014:38th

26 February 2015

PL/SQL Championship for 26 February Postponed

We will NOT hold the championship today.

Even if the website becomes available within next two hours, I do not want to take a chance at starting the competition and then having problems before it is done.

We will reschedule for a day and time in March.

Participants will receive an email for a new date and time soon.

But based on requests from the last one, I will put this out idea out now:

What do you think of holding the championship on Saturday?

More specifically, please post a comment here if you are participating in the 2014 PL/SQL championship and you cannot or do not want to compete on Saturday

Three Out of Four Isn't Too Bad

We held two annual championships last week (SQL and Database Design).

We held a third this week on Logic.

They all went pretty smoothly.

In 2.5 hours it is time for the grand finale: the PL/SQL Championship.

And the PL/SQL Challenge website just went down. Possibly another DDOS attack.

I suppose I should feel proud that our website is so high profile, so mission critical, that someone thinks it is worth their time to attack it.

Except I know the site is not all that high profile and is definitely not mission critical.

So I am just really irritated.

Well, worst comes to worst, we will just reschedule.

That's better than having the championship start and then the site goes down.

Because in that case, I have to produce new quizzes. That would be a serious hassle.

24 February 2015

Results of First-ever Database Design Annual Championship

You will find below the rankings for the 2014 championship; the number next to the player's name is the number of times that player has participated in a championship.

Congratulations first and foremost to our top-ranked players:

1st Place: Sean Molloy of United States

2nd Place: Pavel Zeman of Czech Republic

3rd Place: Justin Cave of United States


As you can see in the table below, the ranking was very tight, with the top two players both getting 91% correct, and the next four all with 87% correct.

Next, congratulations to everyone who played in the championship. I hope you found it entertaining, challenging and educational. And for those who were not able to participate in the championship, you can take the quizzes next week through the Practice feature. We will also make the championship as a whole available as a Test, so you can take it just like these players did.

Thanks and congratulations to the Database Design Quizmaster, Chris Saxon, also our brand-new Oracle Developer Advocate for SQL.

Steven Feuerstein

Rank Name Country Total Time % Correct Total Score
1Sean Molloy (1)United States23 mins 21 secs91%2657
2Pavel Zeman (1)Czech Republic38 mins 25 secs91%2596
3Justin Cave (1)United States23 mins 14 secs87%2457
4Elic (1)Belarus28 mins 30 secs87%2436
5mentzel.iudith (1)Israel28 mins 34 secs87%2436
6Sandra99 (1)Italy34 mins 22 secs87%2413
7Stelios Vlasopoulos (1)Belgium35 mins 22 secs83%2259
8Viacheslav Stepanov (1)Russia20 mins 06 secs78%2220
9Andrey Zaytsev (1)Russia35 mins 43 secs78%2207
10Eric Levin (1)United States38 mins 55 secs78%2194
11Christoph Hillinger (1)Austria15 mins 06 secs78%2190
12Michal Cvan (1)Slovakia36 mins 31 secs78%2154
13Siim Kask (1)Estonia20 mins 26 secs74%2118
14Jan van Overveld (1)Netherlands23 mins 26 secs74%2106
15Niels Hecker (1)Germany36 mins 56 secs78%2102
16Ivan Blanarik (1)Slovakia19 mins 30 secs74%2072
17Chad Lee (1)United States32 mins 45 secs74%2069
18_tiki_4_ (1)Germany08 mins 35 secs74%2066
19Kuvardin Evgeniy (1)Russia28 mins 49 secs74%1985
20Chase Mei (1)Canada07 mins 58 secs70%1968
21Joaquin Gonzalez (1)Spain16 mins 33 secs70%1934
22danad (1)Czech Republic30 mins 46 secs70%1927
23Maxim Borunov (1)Russia35 mins 53 secs70%1906
24Pavel Noga (1)Czech Republic39 mins 31 secs70%1892
25Oleksiy Varchyn (1)Norway12 mins 57 secs65%1848
26Jan Šerák (1)Czech Republic29 mins 45 secs65%1831
27Leszek Grudzień (1)Poland18 mins 23 secs65%1826
28Manfred Kleander (1)Austria36 mins 13 secs70%1805
29Rytis Budreika (1)Lithuania07 mins 16 secs65%1771
30Michal P. (1)Poland22 mins 26 secs65%1760
31Anna Onishchuk (1)Ireland15 mins 50 secs65%1737
32Marcus Matzberger (1)Germany22 mins 19 secs61%1661
33Sachi (1)India11 mins 00 secs57%1606
34Henry Abeska (1)Czech Republic13 mins 08 secs61%1597
35Mehrab (1)United Kingdom39 mins 16 secs61%1593
36Naresh Kumar (1)Malaysia30 mins 22 secs61%1579
37Krzysztof Helbin (1)Poland19 mins 07 secs61%1574
38PZOL (1)Hungary34 mins 30 secs61%1562
39Tobias Stark (1)Germany27 mins 01 secs57%1542
40dannyg64 (1)United States19 mins 14 secs57%1523
41João Barreto (1)Portugal30 mins 57 secs57%1476
42MarkM. (1)Germany28 mins 53 secs48%1184
43Ravshan Abbasov (1)Uzbekistan28 mins 13 secs43%1087
44Scott Wesley (1)Australia00 mins 45 secs17%397

21 February 2015

Results of Annual SQL Championship for 2014

You will find below the rankings for the 2014 SQL Championship; the number next to the player's name is the number of times that player has participated in a championship.

Congratulations first and foremost to our top-ranked players:

1st Place: Andrey Zaytsev of Russia

2nd Place: Pavel Zeman of Czech Republic

3rd Place: Chad Lee of United States


Next, congratulations to everyone who played in the championship. I hope you found it entertaining, challenging and educational. And for those who were not able to participate in the championship, you can take the quizzes next week through the Practice feature. We will also make the championship as a whole available as a Test, so you can take it just like these players did.

Thanks and congratulations to the SQL Quizmaster, Kim Berg Hansen, and Oracle Developer Advocate for SQL, Natalka Roshak, for creating such excellent quizzes! Finally, no championship of this quality could ever happen without the careful work of our amazing reviewer, Elic (aka, Vitaliy Lyanchevskiy).

Steven Feuerstein

Note: Below the table of results for this championship, you will find another list showing the championship history of each of these players.

Rank Name Country Total Time % Correct Total Score
1Andrey Zaytsev (1)Russia44 mins 20 secs84%5373
2Pavel Zeman (1)Czech Republic44 mins 38 secs84%5371
3Chad Lee (2)United States35 mins 15 secs82%5259
4Niels Hecker (2)Germany42 mins 23 secs82%5230
5Christoph Hillinger (2)Austria19 mins 57 secs80%5170
6Jerry Bull (2)United States35 mins 43 secs80%5107
7Stelios Vlasopoulos (2)Belgium43 mins 09 secs80%5077
8Rytis Budreika (2)Lithuania18 mins 56 secs77%5024
9Scott Wesley (2)Australia22 mins 45 secs77%5009
10Tobias Stark (2)Germany43 mins 56 secs77%4924
11Ivan Blanarik (2)Slovakia26 mins 51 secs73%4693
12Justin Cave (2)United States38 mins 34 secs73%4646
13Anna Onishchuk (2)Ireland16 mins 53 secs70%4582
14Oleksiy Varchyn (1)Norway20 mins 38 secs70%4567
15Sean Molloy (2)United States27 mins 45 secs70%4539
16gobruins (1)United States30 mins 11 secs70%4529
17Leszek Grudzień (2)Poland24 mins 31 secs68%4402
18Jason H (2)United States26 mins 00 secs68%4396
19Michal Cvan (2)Slovakia38 mins 35 secs68%4346
20mentzel.iudith (2)Israel41 mins 04 secs68%4336
21Eric Levin (2)United States42 mins 17 secs68%4331
22Viacheslav Stepanov (2)Russia29 mins 24 secs66%4232
23AndreyBerliner (1)Ukraine32 mins 13 secs66%4221
24Sandra99 (1)Italy34 mins 09 secs66%4213
25swart260 (2)Netherlands35 mins 57 secs66%4206
26tonyC (1)United Kingdom39 mins 06 secs66%4194
27_tiki_4_ (2)Germany11 mins 16 secs64%4155
28Rakesh Dadhich (2)India22 mins 09 secs64%4111
29Ravshan Abbasov (1)Uzbekistan33 mins 29 secs64%4066
30Pavel Noga (1)Czech Republic44 mins 53 secs64%4020
31Yuan Tschang (2)United States44 mins 51 secs61%3871
32Chase Mei (2)Canada29 mins 30 secs59%3782
33Kuvardin Evgeniy (2)Russia30 mins 56 secs59%3776
34Hertha Rettinger (2)Germany31 mins 29 secs57%3624
35Mehrab (1)United Kingdom44 mins 48 secs57%3571
36Arūnas Antanaitis (1)Lithuania16 mins 45 secs55%3533
37VictorD (1)Russia24 mins 43 secs55%3501
38Krzysztof Helbin (2)Poland26 mins 24 secs55%3494
39NarendraReddy (1)India21 mins 30 secs50%3214
40Sachi (2)India44 mins 42 secs41%2521

Championship Performance History

After each name, the quarter in which he or she played, and the ranking in that championship.

 
Name History
Andrey Zaytsev2014:1st
Pavel Zeman2014:2nd
Chad Lee2013:31st, 2014:3rd
Niels Hecker2013:7th, 2014:4th
Christoph Hillinger2013:2nd, 2014:5th
Jerry Bull2014:6th
Stelios Vlasopoulos2013:27th, 2014:7th
Rytis Budreika2013:22nd, 2014:8th
Scott Wesley2013:12th, 2014:9th
Tobias Stark2013:39th, 2014:10th
Ivan Blanarik 2013:15th, 2014:11th
Justin Cave2013:17th, 2014:12th
Anna Onishchuk2013:28th, 2014:13th
Oleksiy Varchyn2014:14th
Sean Molloy2013:30th, 2014:15th
gobruins2014:16th
Leszek Grudzień2013:8th, 2014:17th
Jason H2013:26th, 2014:18th
Michal Cvan2013:18th, 2014:19th
mentzel.iudith2013:4th, 2014:20th
Eric Levin2013:19th, 2014:21st
Viacheslav Stepanov2013:21st, 2014:22nd
AndreyBerliner2014:23rd
Sandra992014:24th
swart2602013:37th, 2014:25th
tonyC2014:26th
_tiki_4_2014:27th
Rakesh Dadhich2014:28th
Ravshan Abbasov2014:29th
Pavel Noga2014:30th
Yuan Tschang2013:24th, 2014:31st
Chase Mei2013:11th, 2014:32nd
Kuvardin Evgeniy2014:33rd
Hertha Rettinger2013:36th, 2014:34th
Mehrab2014:35th
Arūnas Antanaitis2014:36th
VictorD2014:37th
Krzysztof Helbin2013:25th, 2014:38th
NarendraReddy2014:39th
Sachi2013:9th, 2014:41st