POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the TRUNCATE command used for in PostgreSQL?

How does TRUNCATE differ from the DELETE command in PostgreSQL?

Can you use the TRUNCATE command on a table that has foreign key references?

What happens to the sequences associated with a table when you TRUNCATE it in PostgreSQL?

Is TRUNCATE considered a DDL (Data Definition Language) or DML (Data Manipulation Language) command in PostgreSQL, and why?

Explain how the CASCADE option works with the TRUNCATE command in PostgreSQL.

What are the performance implications of using TRUNCATE compared to DELETE for large tables in PostgreSQL?

How does the TRUNCATE command affect table-level locks in PostgreSQL?

Describe a scenario where using TRUNCATE might not be suitable in PostgreSQL.

Discuss the implications of using TRUNCATE with the RESTART IDENTITY option in PostgreSQL.