What command will correctly restore a backup made with the following command?

pg_dump -Fc dbname > filename

How do you select a single random row from a table?

PostgreSQL triggers can be written in C directly.

A steel production company has two sales outlets. Both outlets are maintaining their data separately in servers SVA and SVD. Both outlets use the same structure for the Sales table. Which method will you use to create a combined sales report for both the outlets?

Which of the following is correct with regard to Password Authentication?

What is the default variable for the PROMPT3?

What can be stored in a column of type decimal(4,3)?

When using LIKE to compare strings, what is the wildcard operator (operator which matches zero or more characters)?

What kind of triggers are offered by PostgreSQL?

What is the well known port number for the postgresql database service?

The following statement will retrieve the second element of the array column products in table store_products.

SELECT products[1] FROM store_products;