Deadlocks occur when:

When using a SELECT statement on a table, or group of tables, those resources are locked exclusively.

Tablespaces:

If you don’t specify ASC or DESC, PostgreSQL will assume you want to see results:

A tablespace is the place where database objects are stored on disk.

When you want to use a join between columns that are in the same table, you use what type of join?

There are two tables A and B. You are retrieving data from both tables where all rows from table B and only matching rows from table A should be displayed. Which type of join will you apply between tables A and B?

What is the error in the following query if the students table contains several records?

       select name from students where name =

     (select name from students order by name);

Every Boyce-Codd Normal Form(BCNF) is in:

Which of the following geometric types is not defined in PostgreSQL?

Which of the following can be used to uniquely identify a row?