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
- 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:
- vacuum dept;
- vacuum freeze dept;
- analyze dept;
- vacuum full dept;
Keep watching this space for more questions, questions will be coming up on #QuestionADay Series, Go thru CaseStudy category for case studies on PostgreSQL.
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.