November 25, 2022

40 Best (Aurora) PostgreSQL Interview Questions - part 2

40 Top PostgreSQL/Aurora Postgres DBA Interview Questions - Part2


Q21. Which are the methods PostgreSQL provides to create a new database?
AnswerPostgreSQL provides the following methods to create a new database:
  • Using CREATE DATABASE, an SQL command
  • Using created a command-line executable

Q22. How do you delete the database in PostgreSQL?
Answer: We can delete the database by using any one of the below options:
  • Using DROP DATABASE, an SQL command
  • Using dropdb a command-line executable

Q23. What is table partitioning in Postgres?
Answer:

Q24. Explain PostgreSQL Inheritance. How does PostgreSQL implement table inheritance? What is the use of it?
Answer:

Q25. What types of indexes are supported in PostgreSQL?
Answer:

Q26. How to take the backup of PostgreSQL?
Answer:

Q27. What is a CTID of PostgreSQL?
Answer:

Q28. What are the different datatypes in PostgreSQL?
Answer:

Q29. How are stats/statistics updated in PostgreSQL?
Answer:

Q30. How to start a PostgreSQL database server?
Answer:

Q31. How To stop the PostgreSQL database server?
Answer:

Q32. How to check the status of the PostgreSQL server running or not?
Answer:

Q33. How to get a list of databases in a PostgreSQL cluster?
Answer:

Q34. How to take differential or incremental backup of PostgreSQL database?
Answer: There is NO utility for differential or incremental backups.

Q35. How to upgrade the Postgres database server?
Answer:

Q36. How crash recovery works in Postgres?
Answer:

Q37. What are the default tablespaces created in Postgres?
Answer:

Q38. What are the levels of isolation?
Answer:

Q39. How to setup logical replication between two AWS Aurora Postgres clusters?
Answer:

Q40. 
Answer:


Related Postgres Articles: PostgreSQL/Aurora Postgres Database Interview Questions Part1

No comments:

Post a Comment