Choose the correct statement regarding WAL in PostgreSQL:

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

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

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

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?

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

Which authentication methods are supported by PostgreSQL?

Which kind of index can be declared unique?

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

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

Which index types are supported by PostgreSQL?