The basic psql command to list tables is?

VACUUM FULL shrinks indexes, optimizing database performance.

WAL stands for:

Deadlocks occur when:

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

Tablespaces:

Which of the following are valid in a declare block?

Which of the following clauses are not allowed in a single row sub-query?

Which of the following functionalities is supported by the pg_ctl script?

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);