Advertisements
Advertisements
Question
In a company the data is stored in a table under the following fields Employee number, Last name, Date of birth, Address. Which data type will you use for the above field.
Answer in Brief
Solution
Employee number: INT
Employee Name: VARCHAR
Last Name: VARCHAR
Address: VARCHAR
Date of Birth: DATE
shaalaa.com
Data Types in the DBMS
Is there an error in this question or solution?
APPEARS IN
RELATED QUESTIONS
Tick whichever box is not valid.
Student wants to create a field pincode in a table, which data type he will choose?
Observe the field names of a database given below in ‘Column A’ related to Bus reservation. Write suitable data types for each field in front of the respective field in ‘Column B’.
| Column A (Field Name) |
Column B (Data Type) |
| Passenger Name | |
| Age | |
| Gender | |
| Mobile Number |
