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
Address Designation Date of Joining Subject
Name​

Answer 1

Answer:

Tcode  : number (primary key)

Address Designation Date of Joining : date

Subject  : varchar2

Name​ : varchar2

Explanation:

1)Generally Tcode is a number which is assigned uniquely to each teacher.

2)For date of joining date is the appropriate datatype.

3)subject is sequence of characters so varchar2.

4)Similarly name is also sequence of characters.