SRID values must be in the range of 32-bit unsigned integers, with these restrictions:
- SRID 0 is a valid SRID but cannot be used with DROP SPATIAL REFERENCE SYSTEM.
- If the value is in a reserved SRID range, a warning occurs. Reserved ranges are [0, 32767] (reserved by EPSG), [60,000,000, 69,999,999] (reserved by EPSG), and [2,000,000,000, 2,147,483,647] (reserved by MySQL). EPSG stands for the European Petroleum Survey Group.
- Users should not drop SRSs with SRIDs in the reserved ranges. If system-installed SRSs are dropped, the SRS definitions may be recreated for MySQL upgrades.

Available at: <https://dev.mysql.com>. Access on: 6 Mar. 2021.

According to the presented excerpt from the documentation, mark the correct alternative.

Question

SRID values must be in the range of 32-bit unsigned integers, with these restrictions:

- SRID 0 is a valid SRID but cannot be used with DROP SPATIAL REFERENCE SYSTEM.

- If the value is in a reserved SRID range, a warning occurs. Reserved ranges are [0, 32767] (reserved by EPSG), [60,000,000, 69,999,999] (reserved by EPSG), and [2,000,000,000, 2,147,483,647] (reserved by MySQL). EPSG stands for the European Petroleum Survey Group.

- Users should not drop SRSs with SRIDs in the reserved ranges. If system-installed SRSs are dropped, the SRS definitions may be recreated for MySQL upgrades.

Available at: <https://dev.mysql.com>. Access on: 6 Mar. 2021.

According to the presented excerpt from the documentation, mark the correct alternative.

IADES · Answer

If SRSs installed by the system are removed, the SRS definitions cannot be recreated.

IADES · Answer

An SRID value can be any integer, as long as it fits within a 32-bit representation.

IADES · Answer

The value 62,983,467 for SRID triggers a warning.

IADES · Answer

The value -15 is a valid SRID.

IADES · Answer

The value 0 is an invalid SRID and can be used with DROP SPATIAL REFERENCE SYSTEM.

SRID values must be in the range of 32-bit unsigned integers, with these restrictions: - SRID 0 is a valid SRID but cann...

Questões relacionadas para praticar

SRID values must be in the range of 32-bit unsigned integers, with these restrictions: - SRID 0 is a valid SRID but cann...

Questões relacionadas para praticar