In order to echo all input from script, you use the ________ psql command.

By default, in what subdirectory of the database data directory are WAL logs contained?

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?

What do you understand by the following PL/pgSQL declaration?

c_phone customer.contact_no%TYPE;

Which of the following are not DCL operations?

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?