POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is a Primary Key in PostgreSQL, and why is it important?

How do you define a Primary Key when creating a table in PostgreSQL?

Can a table have more than one Primary Key in PostgreSQL? Why or why not?

How do you add a Primary Key to an existing table in PostgreSQL?

What is a composite Primary Key, and how do you define it in PostgreSQL?

What are the implications of defining a Primary Key on a column in PostgreSQL?

Explain the differences between a Primary Key and a Unique constraint in PostgreSQL.

How can you change the Primary Key of an existing table in PostgreSQL?

Describe a scenario where a composite Primary Key is preferred over a single-column Primary Key in PostgreSQL.

What are the performance considerations when using a Primary Key in PostgreSQL?