40 Top PostgreSQL/Aurora Postgres DBA Interview Questions - Part2
Q21. Which are the methods PostgreSQL provides to create a new database?
Answer: PostgreSQL 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