Which of the following statements will retrieve the number of values stored in an array column?

What interfaces are available in the base distribution of PostgreSQL?

Given a table special_products that inherits from a table store_products, which of the following statements will modify store_products only without affecting its child table?

Which of the following queries will create a table with two fields, 'id' and 'name' with 'id' as an auto incrementing primary key?

In the following list, which operators do a case insensitive string matching?

How will you list the available functions from psql?

What is the command used to import a backup made with pg_dumpall > file.dmp?

For proper results, which of the following should contain a tsvector?

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

Which PostgreSQL version added the enum datatype?

Which function should be used to highlight the results?