When looking at 'ps' output on a unix system, you see the following: postgres 1016 0.1 2.4 6532 3080 pts/1 SN 13:19 0:00 postgres: tgl regression [local] idle in transaction What does "idle in transaction" mean?

Advisory locks are allocated out of a shared memory pool whose size is defined by the configuration variables....

This is used to determine how text is stored and sorted within PostgreSQL?

True or False? Dynamic Tracing is enabled by default at compile time.

Which statement is true about PostgreSQL data types?

PostgreSQL supports Index Only Scans.

Which of the following statements is not correct about creating a new operator?

In which of the following ways can a value in an array column be modified?

What is the correct order of clauses in the select statement?

1        select

2        order by

3        where

4        having

5        group by

Which of the following is not a single value function?

Which of the following holds true when creating the function for a PL/pgSQL call handler, and installing PL/pgSQL in the default directory?