PostgreSQL Online Test

1. What is the purpose of a "pg_dump" with the "--format=c" option?

To create a custom-format backup file To create a plain-text SQL file To optimize query performance To copy binary database files

2. What is the purpose of the "WINDOW" clause in a PostgreSQL query?

To define a window frame for window functions To specify the window size To restrict access to certain rows To create a virtual table

3. What is the purpose of a "pg_dump" command in PostgreSQL?

To create a logical backup of a PostgreSQL database To physically copy database files To restore a database from a backup To optimize query performance

4. What is the primary purpose of "ST_GeomFromText" in PostgreSQL's geospatial features?

To create a geometry from Well-Known Text (WKT) representation To create a new database To optimize query performance To manage user roles

5. In PostgreSQL, what is the term for a standby server that is in "hot standby" mode, ready to take over as the primary?

Hot Standby Active Standby Primary Standby Warm Standby

6. What is the default port for PostgreSQL?

5432 3306 1521 27017

7. What is a recursive common table expression (RCTE) in PostgreSQL used for?

To handle hierarchical data and recursive queries To create temporary tables To join multiple tables To define primary keys

8. What type of licensing does PostgreSQL use?

Open source Closed source Proprietary Freeware

9. What happens to a database connection when a client application disconnects from the database in a connection pool setup?

The connection is returned to the pool for reuse The connection is permanently closed The connection is encrypted The connection remains cached

10. What does the "hstore" extension in PostgreSQL allow you to store and manage?

Key-value pairs Images Arrays XML data

11. What does the "BEGIN" statement do in PostgreSQL transactions?

Initiates a new transaction Commits the transaction to save changes Rolls back the transaction Locks the database for exclusive access

12. Which geospatial format is supported by the "WKT" abbreviation in PostgreSQL's geospatial features?

Well-Known Text Web Key Token Web Knowledge Transfer Web Kinetic Technology

13. What is the role of "cubes" in multidimensional analysis in data warehousing with PostgreSQL?

Cubes provide a structured way to aggregate and explore data for analytical purposes Cubes are used for storing binary data Cubes manage database indexes Cubes optimize query performance

14. Which tool is used to configure and manage connection pooling in PostgreSQL?

"pgBouncer" "pgAdmin" "psql" "pg_dump"

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

To store and manipulate case-insensitive text To create new databases To provide encryption for data at rest To create database indexes

16. Which data type is used to store a single character in PostgreSQL?

CHAR STRING CHAR(1) CHARACTER

17. How do you retrieve all columns from a table named "employees" in PostgreSQL?

SELECT * FROM employees SELECT columns(*) FROM employees RETRIEVE ALL employees SELECT TABLE employees

18. What is the purpose of "connection pooling" in PostgreSQL for managing large datasets?

To efficiently manage and reuse database connections, reducing overhead To increase the complexity of SQL queries To encrypt data during transmission To create new databases

19. Which PostgreSQL extension is used to provide enhanced geospatial functions and data types for advanced GIS applications?

"PostGIS" "pgBouncer" "pg_dump" "psql"

20. What is the primary benefit of using a "spatial index" in PostgreSQL's geospatial data management?

It significantly improves the performance of spatial queries It creates logical backups It enforces strong password requirements It manages database connections