Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx

______________________________________________

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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux