Question

1. Name the data type that can be used to store the following data :
(a) 03/06/2018 …………………….
(b) $127.00 …………………….
(c) True / False …………………….
(d) Agra Fort …………………….
(e) [email protected] …………………….

Answer 1

Answer:

(a) int

(b) float

(c) boolean

(d) string

(e) string

Answer 2

Answer:

The correct answer to the given question is:

(a) int

(b) float

(c) boolean

(d) string

(e) string

Explanation:

INT:

The INTEGER data type stores whole numbers with a precision of 9 or 10 digits, ranging from -2,147,483,647 to 2,147,483,647.

Because it is a reserved value, the number 2,147,483,648 cannot be utilized. The INTEGER value is generally used to store counts, amounts, and other data since it is stored as a signed binary integer.

FLOAT:

Double precision floating point numbers with up to 17 significant digits are stored in the FLOAT data type. FLOAT is equivalent to C double data type and IEEE 4-byte floating point. The value range for the FLOAT data type is the same as the value range for the double C data type on your computer.

BOOLEAN:
TRUE or FALSE data values are stored as a single byte in the BOOLEAN data type. The internal and literal representations of the BOOLEAN data type are shown in the following table. To determine whether two BOOLEAN values are equal or unequal, you can compare them.

STRING:

CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET are the different string data types. See Section 11.7, "Data Type Storage Requirements," for details on the string data types' storage needs.

#SPJ2