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

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 returns the geometry type of a given geometry?

• ST_GeometryType

• ST_Type

• ST_ShapeType

• ST_GetType

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

• DROP TABLE

• DELETE TABLE

• REMOVE TABLE

• ERASE TABLE

Which PostGIS function is used to convert a geometry to a GeoJSON representation?

• ST_AsGeoJSON

• ST_ToGeoJSON

• ST_ExportGeoJSON

• ST_GeoJSON

Which function in PostGIS is used to transform coordinates from one spatial reference system to another?

• ST_Transform

• ST_Convert

• ST_ChangeSRID

• ST_Project

Which PostGIS function returns the X coordinate of a point geometry?

• ST_X

• ST_XCoord

• ST_GetX

• ST_PointX

Which SQL statement is used to add a new column to an existing table in PostgreSQL?

• ALTER TABLE ADD COLUMN

• MODIFY TABLE ADD COLUMN

• ADD COLUMN TO TABLE

• UPDATE TABLE ADD COLUMN

What does the `SERIAL` data type do in PostgreSQL?

• Creates an auto-incrementing integer column

• Stores a series of text strings

• Defines a serializable transaction

• Creates a sequence for timestamp values

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

• To combine rows from two or more tables based on a related column

• To filter records based on specified conditions

• To create a new table

• To delete records from a table