Which of the following options can be used to create and initialize a new database cluster within your file system?

Choose the correct statement:

Which of the following security features is inbuilt in PostgreSQL?

Which of the following statements regarding ordinary views are incorrect?

You want to update the last modified timestamp in the orders table. The correct way to do this in a PL/pgSQL function, when the parameter integer order_id is passed, would be:

What would happen on compiling and running the following function?

CREATE FUNCTION loop_function (integer) RETURNS integer AS '

  DECLARE

    result integer;

  BEGIN

    result := $1;

    LOOP

      result := result * result;

      EXIT WHEN result >= 15000;

    END LOOP;

    RETURN result;

  END;

' LANGUAGE 'plpgsql';

When restoring a database backed up with pg_dump, it's generally a good idea to enable WAL.

Locks are recorded in:

What is the difference between DO 'some code...' and EXECUTE 'some code...' statements?

Which of the following is not a valid integer array?

To increase server performance, automated CHECKPOINT operations should be setup in cron or Task Scheduler.