POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the JSON data type in PostgreSQL and how is it different from other data types?

How do you define a column with the JSON data type in a PostgreSQL table?

Can you store both JSON objects and arrays in a PostgreSQL JSON column?

How can you insert JSON data into a PostgreSQL table?

What is the difference between the JSON and JSONB data types in PostgreSQL?

How do you query specific keys or values from JSON data in a PostgreSQL table?

Explain how to create an index on a JSONB column in PostgreSQL and why it might be useful.

How can you update a specific key in a JSONB column in PostgreSQL?

Describe how to aggregate JSON data in PostgreSQL using the json_agg function.

Discuss the performance implications of using JSONB over JSON in PostgreSQL for large-scale applications.