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

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?

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

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