What does MCV stand for?

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?

A wholesale merchant shop needs a report about the sale where total sale of the day is more than $50,000. Which of the following will fulfill this requirement?

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