PostgreSQL runs on:

With PostgreSQL, you can access data by

Triggers can be configured to execute when which of the following operations are performed:

We add data to PostgreSQL by using which statement?

The heart of SQL is the __________ statement.

The most common method to get data into a table is to use what command?

Will the following function compile and execute?

DECLARE

   intValue int4;

BEGIN

   intValue := 20 * 20;

   return intValue;

END;

If entity x is existence-dependent on entity y, then what is x called?

You want to manipulate some value in the database upon updation in a trigger function. Which line of the code would be appropriate?

Consider the following structure of the students table:

        rollno        number(4)

        name          varchar(20)

        course        varchar(20)

What will be the query to display the courses in which the number of students enrolled is more than 5?

Which of the following files controls the host based authentication in PostgreSQL?