Which of the following is true about PostgreSQL clients?

Point out the incorrect statement regarding group functions:

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

Which of the following are not DCL operations?

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

c_phone customer.contact_no%TYPE;

What is wrong in this query:

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

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?

Which is NOT true of array indexes?

What is 'index bloat'?

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

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