To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the

Question

madreJ [45]

3 years ago

9

To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the

SQL-99 standard defined the use of persistent stored modules. T/F

Computers and Technology

1 answer:

MrRa [10] · Answer 1 · 2022-05-22T10:08:49+03:00

Answer:

The correct answer is True.

Explanation:

The SQL: 1999 standard calls a Boolean type, but many commercial SQL servers (Oracle Database, IBM DB2) do not support it as a valid column type, a variable type or to allow it in the result set. Microsoft SQL Server is one of the few database systems that correctly supports Boolean type values using its "BIT" data type. Each 8 BIT fields occupy a full byte of disk space. MySQL interprets "BOOLEAN" as a synonym for TINYINT (8-bit signed integer). PostgreSQL provides a Boolean type of standard compliance.