Skip to Main Content

Past Tournament Quizzes

View your results and or take one of these quizzes now.

Filters

Expected format: YYYY-MM-DD
Expected format: YYYY-MM-DD

All Tournaments

Take
Quiz
View
Results
Ended
OnDescending
Feature / Summary / AuthorPlayed InCommentaryScore
2020-01-17 FridayOracle PL/SQL: LPAD

Don't write your own padding algorithms when you can use a built-in function instead.

Author: Steven Feuerstein [40749-6976290]
PL/SQL ChallengeNo Comments
Last: No Comments
-
2020-01-17 FridayJava: Optional

Learn how to use essential Optional methods by solving this Java quiz! 

Author: Rafael Chinelato Del Nero [40847-7017063]
Jump Into JavaNo Comments
Last: No Comments
-
2020-01-17 FridaySQL: LOG

If you need to find out if a number is in the tens, hundreds, thousands, ten-thousands, etc. range, you can either count digits or you can use LOG.

Author: Kim Berg Hansen [40827-7016906]
Select from SQLNo Comments
Last: No Comments
-
2020-01-17 FridayLogic: Deductive Logic

Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.

Author: Eli Feuerstein [40748-6996593]
I Love LogicNo Comments
Last: No Comments
-
2020-01-17 FridayDatabase Design: Unique Indexes

You can create a unique constraint using the leading columns of a non-unique index.

Author: Chris Saxon [40207-7016894]
Dynamite DB DesignNo Comments
Last: No Comments
-
2020-01-10 FridayDatabase Design: Users

You can use GRANT with the IDENTIFIED BY clause to assign privileges and create a user in one statement. The syntax for this is:

grant <privileges> 
  to <username> 
  identified by <password>;

The permissions can be system privileges or roles.

Author: Chris Saxon [40347-6936014]
Dynamite DB DesignNo Comments
Last: No Comments
-
2020-01-10 FridayJava: Map

Learn how to use the putIfAbsent method from a Map and also how to manipulate items inputs.

Author: Rafael Chinelato Del Nero [40707-6946038]
Jump Into JavaNo New Comments
Objections: SUBMITTED
Last: 2020-01-18 10:49:25
-
2020-01-10 FridayOracle PL/SQL: Oracle PL/SQL

TRUNC can transport you back to the first day of the year. BULK COLLECT always fills a collection starting with index value 1. Error codes in the SQL%BULK_EXCEPTIONS pseudo-collection are stored unsigned.

Author: Steven Feuerstein [40667-6925917]
PL/SQL ChallengeNo Comments
Last: No Comments
-
2020-01-10 FridaySQL: COLLATE

COLLATE offers a nice alternative to NLSSORT to perform linguistic or case insensitive sorting. One advantage is that the collation information is being stored as column metadata, allowing it to be easily used in views without extra sorting columns.

Author: Kim Berg Hansen [40668-6935942]
Select from SQLNo Comments
Last: No Comments
-
2020-01-10 FridayLogic: Deductive Logic

Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.

Author: Eli Feuerstein [40607-6836297]
I Love LogicNo Comments
Last: No Comments
-
2020-01-03 FridayJava: Map

Learn how to use the putIfAbsent method from a Map and also how to manipulate items inputs.

Author: Rafael Chinelato Del Nero [40647-6876171]
Jump Into JavaNo Comments
Last: No Comments
-
2020-01-03 FridayDatabase Design: Referential Integrity

You can create foreign keys inline or out-of-line. When creating inline constraints, you omit the FOREIGN KEY clause. With out-of-line constraints you include it.

Author: Chris Saxon [40088-6796522]
Dynamite DB DesignNo Comments
Last: No Comments
-
2020-01-03 FridayLogic: Deductive Logic

Key to solving deductive logic puzzles is coming up with a strategy for identifying and discarding possibilities in a systematic fashion.

Author: Eli Feuerstein [40587-6836290]
I Love LogicNo Comments
Last: No Comments
-
2020-01-03 FridaySQL: MODEL queries - referencing, creating and updating cells

You can use FOR in cell referencing in RULES clause to create cells.

Author: Kim Berg Hansen [40628-6866210]
Select from SQLNo Comments
Last: No Comments
-
2020-01-03 FridayOracle PL/SQL: Implicit Conversion

Oracle PL/SQL implicitly converts values between types when possible and appropriate. You are generally better off converting explicitly (you might uncover an error, for example, or improve SQL performance), but it's nice to see how hard Oracle Database works for you. :-)

Author: Steven Feuerstein [40627-6866205]
PL/SQL ChallengeNo New Comments

Last: 2020-01-02 14:16:43
-
  • 1 - 15