Question

Suggest a suitable data type for the deptname field

Answer 1

char or varchar is the answer

Answer 2

Varchar or char datatype is the correct answer to the given question

Explanation:

• In the database we used the char or varchar datatype to holding any type of character. Depending upon the condition we used this datatype.

• The Varchar is extremely versatile and will consider many data types. Varchar is storing the data of huge length. When we don't know how many characters are stored then we use varchar datatype.  

• The char data type is not versatile as compare to the varchar datatype if we know how many characters are stored then we use char datatype . however the performance of char is better then the varchar datatype.

Learn More:

• brainly.in/question/7550680