Home > Databases > Quizzes > PostgreSQL Fundamentals Test
PostgreSQL Fundamentals Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 26% • Most missed: “PostgreSQL can be installed?”
PostgreSQL Fundamentals Test
Time left 00:00
25 Questions

1. What are the join strategies available to the postgreSQL planner when a SELECT query contains two or more relations?
2. What command turns on timing?
3. True or false: When a table is created which uses a table name as a column type - not null constraints on the column type's table definition are honored by the including table.
4. What is a TOAST file?
5. To create a database that supports UTF-8 - the following command can be used:
6. To prevent transaction wraparound - a VACUUM operation should be run on every table no less than once every:
7. True or False? When using a SELECT statement on a table - or group of tables - those resources are locked exclusively.
8. We add data to PostgreSQL by using which statement?
9. A VACUUM operation is used:
10. What is the difference between DO 'some code...' and EXECUTE 'some code...' statements?
11. True or False? Only the administrator can make use of tablespaces.
12. True or False? PostgreSQL is so lightweight that performance and reliability are not affected by hardware.
13. What does the following statement do? CREATE INDEX lower_title_idx ON books ((lower(title)));
14. PostgreSQL is
15. To copy a database from server1 to server2 - you might use which of the following:
16. PostgreSQL used what model of communication?
17. Which statement is true about PostgreSQL data types?
18. The most common method to get data into a table is to use what command?
19. PostgreSQL can be installed?
20. True or False? ALTER TABLE may be issued while a VACUUM process is running.
21. To describe a table in PostgreSQL which of the following is correct:
22. WAL segment size is determined:
23. A meta-command always begins with what?
24. When you want to use a join between columns that are in the same table - you use what type of join?
25. Which of the following best describes a role:

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs MariaDB Practice Test
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.