A handler named 'plpgsqlHandle()' is created for installing PL/pgSQL. For creating the handler on 'SwineDB' database you would issue a command:

What is the first step for manually installing PL/pgSQL in PostgreSQL?

Which of the following are supported by PostgreSQL?

Food Cart Accounting System (FOCAS) is maintaining products in the products table, and wants to see the products which are 50 or more numbers far from the minimum stock limit. The structure of the Products table is:

        ProductID

        ProductName

        CurrentStock

        MinimumStock

Two possible queries are:

Statement 1: select * from products where currentStock>MinimumStock+50

Statement 2: select * from products where currentStock-50>MinimumStock

Select an option which is more suitable for these queries:

Which of the following programming structures is not available in PL/pgSQL?

Select the appropriate query for the Products table when data should be primarily ordered by ProductGroup. ProductGroup should be displayed in ascending order and CurrentStock should be in descending order:

What command allows you to edit PostgreSQL queries in your favorite editor ?

What does the following statement do? CREATE INDEX lower_title_idx ON books ((lower(title)));

To create a database in PostgreSQL, you must have the special CREATEDB privilege or

A meta-command always begins with what?

Query trees can be viewed in the server logs as long as which of the following configuration parameters are enabled?