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?

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

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:

Which of the following statements regarding ordinary views are incorrect?