Re: Created a PostgreSQL test, what do you think?

On 05/01/2013 09:16 AM, Jsmarterer wrote:

> Let me know if you have any questions and post your scores below!

This test seems out of date and contains arguably incorrect answers.

* True or False? PostgreSQL supports Index Only Scans.
- The test thinks this is false, but such was added in 9.2.

* True or False? When restoring a database object with pg_dump, it's
generally a good idea to enable WAL.
- pg_dump is not used to restore data, but to dump it.
- You can't disable WAL, it's an integral part of the database.
- Perhaps the question meant archive mode for WAL archival?

* True or False? Dynamic Tracing is enabled by default at compile time.
- This refers to Dtrace, which only applies to a very small subset of
compatible OSs. Fairly obscure for most users.

* To restore a PostgreSQL backup created with pg_dump, the following may
be used:
- Several command-line switches can invalidate the answer.

* Bob works for StegaCorp.
- Question is way too long for that timer.

* To describe a table in PostgreSQL which of the following is correct:
- The "correct" answer has an unnecessary semicolon.

* The function used for data encryption/decryption within postgres is:
- pgcrypto is an extension, not a function.

Hopefully these get better peer review in the future. I'm not sure if
you have any control over the coding, but submitted questions should be
voted on by "certified" users, or at least audited, before being added
to the test. Regular reviews are also necessary to catch questions that
become invalid with new PG releases.

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email