What is the effect of turning fsync off in postgresql.conf?

Which kind of index can be declared unique?

Which authentication methods are supported by PostgreSQL?

If max_connections is 10 and 10 connections are currently active, how can you be sure the superuser will be available to connect?

Which function should be used to highlight the results?

Consider the following query:

Create table foo (bar varchar);

What will be the size limit of the bar?

A PL/pgSQL code block is defined with DECLARE, BEGIN and END. How many such sub blocks can be nested within a block?

Which of the following date function(s) are invalid?

Choose the correct statement regarding WAL in PostgreSQL:

Which of the following holds true if you have installed PL/pgSQL in the PgDatabase?

Which of the following is correct for the postmaster -n debugging option?