DATA TYPES IN SQL

What property defines the kind of data stored in a column?

Data Type

What are the three main categories of SQL data types?

String, Numeric, and Date & Time

What data type represents text or sequence of characters?

String Data Type

What string type can represent all world languages and symbols?

Unicode String

What string type stores raw binary data instead of readable text?

Binary String

What data type represents numbers (integers or decimals)?

Numeric Data Type

What numeric type represents whole numbers?

Integer

What numeric type represents decimal or floating-point numbers?

Float/Decimal

What data type represents calendar dates and times?

Date and Time Data Type

What type of variable stores logical values (true or false)?

Boolean

Why is it important to specify data types for columns?

For efficient memory use and accurate data storage

Which SQL data type stores variable-length text?

VARCHAR

Which SQL data type stores fixed-length text?

CHAR

Which SQL data type is used for large blocks of text?

TEXT

Which SQL data type stores monetary values?

MONEY

Which SQL data type stores precise integers?

INT

Which SQL data type stores fractional numbers?

FLOAT

Which SQL data type stores only the date?

DATE

Which SQL data type stores only the time?

TIME

Which SQL data type stores both date and time?

DATETIME

What is the main purpose of string data types?

To handle textual and user-input information

What is the main purpose of numeric data types?

To perform mathematical calculations

What is the main purpose of date and time data types?

To record timestamps and schedule events

What data type is ideal for storing phone numbers?

Integer or VARCHAR

Which data type enhances performance in arithmetic operations?

Numeric (especially Integer and Float)