Question

12. Look at the fields of a table named 'Teacher given below: Write the datatype you will select for
each field giving suitable reason for each one of them.
Tcode T_Name Address Designation Date of Joining Subject

Answer 1

Answer:

Tcode = int

As Tcode contain all numbers, for numbers we used int.

Tname and Subject= varchar or varchar2

Any of both can be used for character

Address= varchar2

As address is long text, that's why we used varchar2 instead of varchar, as varchar has less size than varchar2.

Date of joining- Date

Sql has given different data type for such cases ie, Date