PostGIS and PostgreSQL Quiz

What is the primary function of the PostgreSQL command `SELECT`?

• To query data from a table

• To create a new table

• To delete data from a table

• To update data in a table

Which command is used to create a new database in PostgreSQL?

• CREATE DATABASE

• NEW DATABASE

• ADD DATABASE

• MAKE DATABASE

Which extension in PostgreSQL adds support for geographic objects?

• PostGIS

• PostGeo

• GeoPost

• GISPost

What is the default port number for PostgreSQL?

• 5432

• 3306

• 1521

• 8080

What is the purpose of the PostgreSQL `WHERE` clause?

• To filter records based on specified conditions

• To join multiple tables

• To sort the result set

• To group the result set

Which PostGIS function is used to calculate the area of a geometry?

• ST_Area

• ST_Size

• ST_ShapeArea

• ST_CalculateArea

Which command in PostgreSQL is used to remove an existing table?

• DROP TABLE

• DELETE TABLE

• REMOVE TABLE

• ERASE TABLE

Which data type in PostgreSQL is used to store text of variable length?

• VARCHAR

• TEXT

• STRING

• CHAR

Which PostGIS function returns the geometry type of a given geometry?

• ST_GeometryType

• ST_Type

• ST_ShapeType

• ST_GetType

Which PostGIS function is used to calculate the length of a geometry?

• ST_Length

• ST_Distance

• ST_LineLength

• ST_Perimeter