PostgreSQL triggers can be written in C directly.

Which index types are supported by PostgreSQL?

What command will correctly restore a backup made with the following command? pg_dump -Fc dbname > filename

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?

Which of the following is not true regarding single row functions?

Examine the following query:

Create table Person

(EmpNo Number(4) not null,

EName Char not null,

Join_dt Date not null,

Pay Number)

Which of the following field(s) are created correctly?

Normalization divides tables in a more useful and meaningful manner. Which statement is correct for the FIRST NORMAL FORM?

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?