美国PostgreSQL DBA面试真题

小布 21天前 88

以下内容均来自美国学员面试过程中雇主提出的问题。

樱桃溪学院会持续搜集、整理、分析这些问题,然后融入到日常的教学过程中。这是一项极其重要的工作,我们坚信:只要常抓不懈,樱桃溪学院的就业率可以超过80%。

 

----------------2025/02/04----

  1. What’s your day to day operations in Wells Fargo? What do you do everyday?
  2. Why do you look for this change now?
  3. In Postgres, what is the difference between the physical and logical backup?
  4. How do you inspect the wal file that we Postgres?
  5. What is the use of pg_rewind?
  6. What is streaming vs logical replication?
  7. How do you monitor the replication lag between primary database and standby database?
  8. How to convert a role to a user in Postgres?
  9. How to stop a particular database in the cluster?
  10. What are the different options and modes in pg_ctl?
  11. What is the smart option in pg_ctl?
  12. What is the difference between explain and explain analyze?
  13. Any experience in migrating Postgres to Oracle?
  14. What is the default streaming replication mode in Postgres? Is it synchronous or asynchronous?
  15. How will you handle the performance issue in Postgres?
  16. What are the different types of indexes in Postgres?
  17. Can we take an incremental backup and Postgres?
  18. How does Postgres handle crash recovery?

 

最新回复 (0)
返回
发新帖