Which is NOT true of array indexes?

Bob works for StegaCorp. His workstation's IP address is 10.5.34.8. He needs access to a database called 'partners' directly from his workstation. Which of the following is the correct entry in pg_hba.conf?

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?

Point out the incorrect statement regarding group functions:

Which of the following is true about PostgreSQL clients?

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: