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

SELECT products[1] FROM store_products;

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

What kind of triggers are offered by PostgreSQL?

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

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

What is the default ordering when ORDER BY is not specified?

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

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?

PostgreSQL triggers can be written in C directly.

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

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

pg_dump -Fc dbname > filename