To restore a PostgreSQL backup created with pg_dump, the following may be used:

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 is wrong in this query:

Select * from Orders where OrderID=(select OrderID from OrderItems where ItemQty>50)

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: