PostgreSQL Online Test

Instructions:

  • This practice test has 20 questions
  • You have to attempt all the questions
  • Time will be 05:00 minute for 20 questions. After 05:00 minute, practice test will be submitted automatically and you will redirect to result page.
  • This practice test is for self evalutation, if you get less marks then passing marks. Please prepare more for get excellent mark next time
  • Best of luck :)
Time: 05:00 minutes Passing Marks: 60%

1. What is the "citext" extension used for in PostgreSQL?

2. Who developed PostgreSQL?

3. What is the purpose of "pg_logical" replication in PostgreSQL tools and clients?

4. What is the purpose of "GIN" and "GiST" indexing methods in PostgreSQL's NoSQL support?

5. What is "synchronous replication" in PostgreSQL?

6. In PostgreSQL, what is a "nested transaction"?

7. What is the purpose of the "pg_restore" command in PostgreSQL tools?

8. In PostgreSQL, what is the significance of "autovacuum" for managing large datasets?

9. What is the purpose of the "UPDATE" statement in PostgreSQL?

10. What is the "pg_stat_statements" module used for in PostgreSQL tools and clients?

11. Which programming languages can be used to interact with PostgreSQL?

12. How can you install PostgreSQL on a Linux system?

13. What is the "pgcrypto" extension in PostgreSQL primarily used for?

14. What is the role of the 'pg_ctl' utility in PostgreSQL?

15. What does the "DELETE" statement in PostgreSQL do?

16. Which PostgreSQL command is used to perform a point-in-time recovery (PITR) from a continuous archive of WAL files?

17. Which SQL statement is used to filter rows in a table based on a specified condition?

18. Which PostgreSQL authentication method allows access without a password but is restricted to local connections on Unix-like systems?

19. What does the "COPY" command do in PostgreSQL data management?

20. Which PostgreSQL feature is used to encrypt data transmission between clients and the server using SSL/TLS?