What is "index bloat"?

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.

What do you infer from the following two lines?

1. host        all        192.168.1.10        255.255.255.255        reject

2. host        all        127.0.0.1             255.255.255.255        trust

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