What are the join strategies available to the postgreSQL planner when a SELECT query contains two or more relations?

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:

Which of the following holds true when you have defined a function with "isstrict" attribute?

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?