To copy a database from server1 to server2, you might use which of the following:

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

Which of the following is not a valid integer array?

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

Locks are recorded in:

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

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';

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:

Which of the following statements regarding ordinary views are incorrect?

Which of the following security features is inbuilt in PostgreSQL?

Choose the correct statement: