Blog

Sample PostgreSQL Certification Questions

The PostgreSQL certification questions mentioned below are just for understanding purpose and we do not guarantee that they appear in the exam. Please read the questions to understand the difficulty level of the certification exam.

Sample PostgreSQL Certification Questions

  1. You are working as a PostgreSQL DBA, you want to remove all obsoleted rows of the “dept” table from disk to minimize the size of the data files for this table.which of the following statements can be used to recover the space used by obsoleted rows of the “dept” table.

Options:

  1. vacuum dept;
  2. vacuum freeze dept;
  3. analyze dept;
  4. vacuum full dept;

Ans: 4

Explanation:

To recover the space to disk we need to do vacuum full.

  1. Option 1, to empty the space but it will not recover the space to disk.
  2. Option 2, It will freeze the table to avoid transaction id wraparound issues.
  3. Option 3, To gather the statistics.
  4. Hence Option 4 is correct.

 

Keep watching this space for more questions, questions will be coming up on #QuestionADay Series, Go thru CaseStudy category for case studies on PostgreSQL.

Pages: 1 2 3 4 5 6
Tags:

This Post Has One Comment

  1. Sachin Bhatia February 19, 2023

    Hi, I would like to give the PostgreSQL Associate Exam then Professional certification. Could you please guide me from where and which training I should do before to prepare for all the exams topics according to syllabus. Thanks.

Leave a Reply