POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is a UNIQUE constraint in PostgreSQL?

Can a table have multiple UNIQUE constraints in PostgreSQL?

What is the difference between a PRIMARY KEY and a UNIQUE constraint in PostgreSQL?

How does PostgreSQL handle NULL values with a UNIQUE constraint?

Can you apply a UNIQUE constraint to multiple columns in PostgreSQL?

What happens if you try to insert a duplicate value in a column with a UNIQUE constraint in PostgreSQL?

Explain the significance of UNIQUE constraints in PostgreSQL in terms of query optimization.

How do you manage UNIQUE constraint violations during bulk data loading in PostgreSQL?

Discuss the potential challenges of using UNIQUE constraints in distributed PostgreSQL databases.

Describe a scenario where using a UNIQUE constraint in PostgreSQL might be more appropriate than using a PRIMARY KEY.