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. True or False? To increase server performance - automated CHECKPOINT operations should be setup in cron or Task Scheduler.
2. When you want to use a join between columns that are in the same table - you use what type of join?
3. PostgreSQL is:
4. To copy a database from server1 to server2 - you might use which of the following:
5. To create a database that supports UTF-8 - the following command can be used:
6. What is the wrapper around the SQL command CREATE DATABASE?
7. What does MCV stand for?
8. To restore a PostgreSQL backup created with pg_dump - the following may be used:
9. PostgreSQL can be installed?
10. The syntax to view the indexes of an existing postgreSQL table is:
11. In PostgreSQL - a named collection of tables is called what?
12. True or False? ALTER TABLE may be issued while a VACUUM process is running.
13. Asynchronous Commits:
14. Which of the following is NOT a feature of user defined functions?
15. With PostgreSQL - you can access data by
16. Which is NOT true of array indexes?
17. If you don-™t specify ASC or DESC - PostgreSQL will assume you want to see results:
18. The basic psql command to list tables is?
19. True or False? When using a SELECT statement on a table - or group of tables - those resources are locked exclusively.
20. To create a database in PostgreSQL - you must have the special CREATEDB privilege or
21. PostgreSQL can be used from just about any major programming language - including C - C++ - Perl - Python - Java - Tcl - and PHP.
22. True or False? Within a table - a single column may be encrypted.
23. The value NULL - in database terminology - means?
24. What is the difference between DO 'some code...' and EXECUTE 'some code...' statements?
25. PostgreSQL is

⚡ 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.