The ________ type stores a currency amount with a fixed fractional precision.

PostgreSQL - Quiz(MCQ)

binary

money

numeric

character

Correct Answer : money

Explanation : The money type stores a currency amount with a fixed fractional precision. Values of the numeric, int, and bigint data types can be cast to money. Using Floating point numbers is not recommended to handle money due to the potential for rounding errors.

Recently Updated in PostgreSQL Questions

What is one mistake network administrators often make from a security perspective?

Using domain admin privileged accounts for day-to-day non-admin use.

Enforcing password security on users who do not require it.

Forgetting passwords on systems since they have too many passwords.

Not writing passwords down in a safe place, such as a sticky note on your workstation.

Correct Answer : Using domain admin privileged accounts for day-to-day non-admin use.