Loading, please wait...

PostgreSQL MCQ Quiz (Multiple Choice Questions And Answers)

Search here for MCQs

Are you preparing for the next job interviews? If yes, trust me this post will help you also we'll suggest you check out a big collection for Programming Full Forms that may help you in your interview:

List of Programming Full Forms 

11. A VACUUM operation is used:

  • To recover or reuse disk space occupied by updated or deleted rows
  • To protect against loss of very old data due to transaction ID wraparound.
  • To update data statistics used by the PostgreSQL query planner.
  • All of these

12. The core PostgreSQL source code includes what interfaces?

  • Ruby and PHP interfaces
  • C++ and Java interfaces
  • The C and embedded C interfaces
  • VB and VB.NET interfaces

13. Unless you specify NOT NULL, PostgreSQL will assume that a column is:

  • Required
  • Optional
  • Integers
  • Text

14. To describe a table in PostgreSQL which of the following is correct:

  • psql> \D table_name
  • psql> describe table_name
  • psql> DESCRIBE table_name
  • psql> \d table_name

15. The value NULL, in database terminology, means?

  • The value is undetermined at this time
  • The value is undetermined
  • The value is not relevant for this particular row.
  • All of these